##### Page tree

Outdated release! Latest docs are Release 8.2: ASIN Function

For input values between -1 and 1 inclusive, this function returns the angle in radians whose sine value is the input. This function is the inverse of the sine function. The value can be a Decimal or Integer literal or a reference to a column containing numeric values.

NOTE: While this function returns values outside of the range -1 <= x <= 1, those values are not considered valid.

Arc cosecant:

The arc secant function is computed as follows:

Input RangeOutput computation
x<=-1`asin(1/x)`
x>=1`asin(1/x)`
-1<x<1Not valid

## Basic Usage

Numeric literal example:

asin(0.5)

Output: Returns the computation of the arc sine of 0.5. Output value is in radians.

Column reference example:

asin(X)

Output: Returns the arc sine of the values in `X` column.

## Syntax and Arguments

asin(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

### 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 literal`10`

## Examples

### Example - Trigonometry Arc functions

This example illustrates how to apply the inverse trigonometric (Arc) functions to your transformations.

NOTE: These functions are valid over specific ranges.

• Arcsine. See ASIN Function.
• Arccosine. See ACOS Function
• Arctangent. See ATAN Function.
• Arccotangent. Computed using ATAN function. See below.
• Arcsecant. Computed using ACOS function. See below.
• Arccosecant. Computed using ASIN function. See below.

Source:

In the following sample, input values are in radians. In this example, all values are rounded to two decimals for clarity.

Y
-1.00
-0.75
-0.50
0.00
0.50
0.75
1.00

Transformation:

Arcsine:

Valid over the range (-1 <= Y <= 1)

Transformation Name `New formula` `Single row formula` `round(degrees(asin(Y)), 2)` `'asinY'`

Arccosine:

Valid over the range (-1 <= Y <= 1)

Transformation Name `New formula` `Single row formula` `round(degrees(acos(Y)), 2)` `'acosY'`

Arctangent:

Valid over the range (-1 <= Y <= 1)

Transformation Name `New formula` `Single row formula` `round(degrees(atan(Y)), 2)` `'atanY'`

Arccosecant:

This function is valid over a set of ranged inputs, so you can use a conditional column for the computation. For more information, see ASIN Function.

Transformation Name `Conditional column` `if...then...else` `(Y <= -1) || (Y >= 1)` `round(degrees(asin(divide(1, Y))), 2)` `'acscY'`

Arcsecant:

Same set of ranged inputs apply to this function. For more information, see ACOS Function.

Transformation Name `Conditional column` `if...then...else` `(Y <= -1) || (Y >= 1)` `round(degrees(acos(divide(1, Y))), 2)` `'asecY'`

Arccotangent:

For this function, the two different ranges of inputs have different computations, so an `else` condition is added to the transformation. For more information, see ATAN Function.

Transformation Name `Conditional column` `if...then...else` `Y > 0` `round(degrees(atan(divide(1, Y))), 2)` `round(degrees(atan(divide(1, Y)) + pi()), 2)` `'acotY'`

Results:

YacotYasecYacscYatanYacosYasinY
-1.00-41.86180.00-90.00-45.00180.00-90.00
-0.75-49.99nullnull-37.00139.00-49.00
-0.50-60.29nullnull-27.00120.00-30.00
0.00nullnullnull0.0090.000.00
0.5063.44nullnull27.0060.0030.00
0.7553.13nullnull37.0041.0049.00
1.0045.000.0090.0045.000.0090.00

• Page:
• Page:
• Page:
• Page:
• Page:
• Page:
• Page:
• Page:
• Page:
• Page:
• Page:
• Page:
• Page:
• Page:
• Page: