ACOS Function

D toc

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

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

For more information on the cosine function, see COS Function.

Arc secant:

The arc secant function is computed as follows:

D s lang vs sql

D s

snippet	Basic

Numeric literal example:

D lang syntax

RawWrangle	true
Type	ref
showNote	true
WrangleText	derive type:single value: acos(0.5)

acos(0.5)

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

Column reference example:

D lang syntax

RawWrangle	true
Type	ref
showNote	true
WrangleText	derive type:single value: acos(X) as: acosX'

acos(X)

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

D s

snippet	Syntax

D lang syntax

RawWrangle	true
Type	syntax
showNote	true
WrangleText	derive type:single value: acos(numeric_value)

acos(numeric_value)

Argument	Required?	Data Type	Description
numeric_value	Y	string, decimal, or integer	Name of column, Decimal or Integer literal, or function returning those types to apply to the function

D s lang notes

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.

D s

snippet	usage

Required?	Data Type	Example Value
Yes	String (column reference) or Integer or Decimal literal	`0.5`

D s

snippet	Examples

Include Page

	EXAMPLE - Trigonometry Arc Functions
	EXAMPLE - Trigonometry Arc Functions

D s also

label	trigonometry

Versions Compared