COS Function

Computes the cosine of an input value for an angle measured in radians. The value can be a Decimal or Integer literal or a reference to a column containing numeric values.

In the above, the cosine of angle A is computed as the following:

cos(A) = y/z

The secant of angle A is 1/cos(A), or:

sec(A) = 1/cos(A) = z/y

You can convert from degrees to radians. For more information, see RADIANS Function.

Basic Usage

Numeric literal example:

round(cos(radians(30)),3)

Output: Returns the computation of the cosine of a 30-degree angle, which is converted to radians before being passed to the COS function. The output value is rounded to three decimals: 0.866.

Column reference example:

cos(X)

Output: Returns the cosine of the radians values in X column.

Syntax

cos(numeric_value)

ArgumentRequired?Data TypeDescription
numeric_valueYstring, decimal, or integerName of column, Decimal or Integer literal, or function returning those types to apply to the function

For more information on syntax standards, see Language Documentation Syntax Notes.

numeric_value

Name of the column, Integer or Decimal literal, or function returning that data type to apply to the function.

  • Missing input values generate missing results.
  • Literal numeric values should not be quoted. Quoted values are treated as strings.
  • Multiple columns and wildcards are not supported.

Usage Notes:

Required?Data TypeExample Value
YesString (column reference) or Integer or Decimal literal0.5

Examples

Example - Trigonometry functions

This example illustrates how to apply basic trigonometric functions to your transformations. All of the functions take inputs in radians.

Source:

In the following sample, input values are in degrees:

X
-30
0
30
45
60
90
120
135
180


Transformation:

In this example, all values are rounded to three decimals for clarity.

First, the above values in degrees must be converted to radians.

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula round(radians(X), 3)
Parameter: New column name 'rX'

Sine:

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula round(sin(rX), 3)
Parameter: New column name 'SINrX'

Cosine:

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula round(cos(rX), 3)
Parameter: New column name 'COSrX'

Tangent:

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula round(tan(rX), 3)
Parameter: New column name 'TANrX'

Cotangent:

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula round(1 / tan(rX), 3)
Parameter: New column name 'COTrX'

Secant:

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula round(1 / cos(rX), 3)
Parameter: New column name 'SECrX'

Cosecant:

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula round(1 / sin(rX), 3)
Parameter: New column name 'CSCrX'


Results:

XrXCOTrXSECrXCSCrXTANrXCOSrXSINrX
-30-0.524-1.731.155-1.999-0.5780.866-0.5
00null1null010
300.5241.731.1551.9990.5780.8660.5
450.7851.0011.4141.4150.9990.7070.707
601.0470.5781.9991.1551.7310.50.866
901.5710-4909.8261-4909.82601
1202.094-0.577-2.0011.154-1.734-0.50.866
1352.356-1-1.4141.414-1-0.7070.707
1803.1422454.913-1-2454.9130-10