Math Operators
- Ashvin Kumaran
- Roza Leyderman
Quick Links
Arithmetic
abs
Calculates the absolute value of a numerical value.
Syntax
| abs(<number>) as <alias>
Examples
| abs(-42) as A
The above example returns A with a value of 42.
ceil
Rounds up a numerical value to the nearest integer.
Syntax
| ceil(<number>) as <alias>
Examples
| ceil(3.14) as C
The above example returns C with a value of 4.
cbrt
Calculates the cube root of a numerical value, ∛
Syntax
| cubeRoot(<number>) as <alias>
Examples
| cubeRoot(27) as R
The above example returns R with a value of 3.
exp
Calculates Euler’s number e raised to the power of a numerical value.
Syntax
| exp(<number>) as <alias>
Examples
| exp(1) as E
The above example returns E with a value of 2.71828.
expm1
Calculates exp(<number>) − 1 for a numerical value; compensates for roundoff errors in Exponential.
Syntax
| expm1(<number>) as <alias>
Examples
| expm1(1) as M
The above example returns M with a value of 1.71828.
floor
Rounds down a numerical value to the nearest integer.
Syntax
| floor(<number>) as <alias>
Examples
| floor(3.14) as F
The above example returns F with a value of 3.
log
Calculates the natural logarithm of a numerical value.
Syntax
| log(<number>) as <alias>
Examples
| log(10) as L
The above example returns L with a value of 2.30258.
round
Rounds the sample values of a numerical value.
Syntax
| round(<number>) as <alias>
Examples
| round(3.5) as R
The above example returns R with a value of 4.
sqrt
Calculates the square root of a numerical value
Syntax
| sqrt(<number>) as <alias>
Examples
| sqrt(16) as S
The above example returns S with a value of 4.
Trigonometric
acos
Calculates the arccosine of a numerical value.
Syntax
| acos(<number>) as <alias>
Examples
| acos(0.5) as A
The above example returns A with a value of 1.0472 (in radians).
asin
Calculates the arcsine of a numerical value.
Syntax
| asin(<number>) as <alias>
Examples
| asin(<number>) as <alias>
The above example returns A with a value of 0.5236 (in radians).
atan
Calculates the arctangent of a numerical value.
Syntax
| atan(<number>) as <alias>
Examples
| atan(1) as T
The above example returns T with a value of 0.7854 (in radians).
cos
Calculates the cosine of a numerical value.
Syntax
| cos(<number>) as <alias>
Examples
| cos(0) as C
The above example returns C with a value of 1.
cosh
Calculates the hyperbolic cosine of a numerical value.
Syntax
| cosh(<number>) as <alias>
Examples
| cosh(0) as H
The above example returns H with a value of 1.
sin
Calculates the sine of a numerical value.
Syntax
| sin(<number>) as <alias>
Examples
| sin(0) as S
The above example returns S with a value of 0.
sinh
Calculates the hyperbolic sine of a numerical value.
Syntax
| sinh(<number>) as <alias>
Examples
| sinh(0) as H
The above example returns H with a value of 0.
tan
Calculates the tangent of a numerical value.
Syntax
| tan(<number>) as <alias>
Examples
| tan(0) as T
The above example returns T with a value of 0.
tanh
Calculates the hyperbolic tangent of a numerical value.
Syntax
| tanh(<number>) as <alias>
Examples
| tanh(0) as H
The above example returns H with a value of 0.