Functions

---

abs(x:)

Returns the absolute value of x.

abs(x: DOUBLE) -> DOUBLE

acos(x:)

Computes the arccosine of x.

acos(x: DOUBLE) -> DOUBLE

asin(x:)

Computes the arcsine of x.

asin(x: DOUBLE) -> DOUBLE

atan(x:)

Computes the arctangent of x.

atan(x: DOUBLE) -> DOUBLE

atan2(y:x:)

Computes the arctangent (y, x).

atan2(y: DOUBLE, x: DOUBLE) -> DOUBLE

cbrt(x:)

Returns the cube root of the number.

cbrt(x: DOUBLE) -> DOUBLE

ceiling(x:)

Rounds the number up.

ceiling(x: DOUBLE) -> DECIMAL

cos(x:)

Computes the cosine of x.

cos(x: DOUBLE) -> DOUBLE

degrees(x:)

Converts radians to degrees.

degrees(x: DOUBLE) -> DOUBLE

exp(x:)

Computes e x.

exp(x: DOUBLE) -> DOUBLE

floor(x:)

Rounds the number down.

floor(x: DOUBLE) -> DECIMAL

is_finite(x:)

Returns true if the floating point value is finite, false otherwise.

is_finite(x: DOUBLE) -> BOOLEAN

is_infinite(x:)

Returns true if the floating point value is infinite, false otherwise.

is_infinite(x: DOUBLE) -> BOOLEAN

is_nan(x:)

Returns true if the floating point value is not a number, false otherwise.

is_nan(x: DOUBLE) -> BOOLEAN

ln(x:)

Computes the natural logarithm of x.

ln(x: DOUBLE) -> DOUBLE

log(x:)

Computes the base-10 logarithm of x.

log(x: DOUBLE) -> DOUBLE

log2(x:)

Computes the base-2 log of x.

log2(x: DOUBLE) -> DOUBLE

pi()

Returns the value of pi.

pi() -> DOUBLE

radians(x:)

Converts degrees to radians.

radians(x: DOUBLE) -> DOUBLE

random()

Returns a random number x in the range 0.0 <= x < 1.0.

random() -> DOUBLE

round(value:decimal_places:)

Round to ‘decimal_places’ decimal places. Values ‘decimal_places’ < 0 are allowed.

round(value: DOUBLE, decimal_places: DOUBLE) -> DOUBLE

power(x:y:)

Computes x to the power of y.

power(x: DOUBLE, y: DOUBLE) -> DOUBLE

sign(x:)

Returns the sign of x as -1, 0 or 1.

sign(x: DOUBLE) -> DOUBLE

sin(x:)

Computes the sin of x.

sin(x: DOUBLE) -> DOUBLE

sqrt(x:)

Returns the square root of the number.

sqrt(x: DOUBLE) -> DOUBLE

tan(x:)

Computes the tangent of x.

tan(x: DOUBLE) -> DOUBLE

truncate(x:)

Truncates the number.

truncate(x: DOUBLE) -> DOUBLE

sinh(x:)

Computes the hyperbolic sine of x.

sinh(x: DOUBLE) -> DOUBLE

cosh(x:)

Computes the hyperbolic cosine of x.

cosh(x: DOUBLE) -> DOUBLE

tanh(x:)

Computes the hyperbolic tangent of x.

tanh(x: DOUBLE) -> DOUBLE

e()

Returns the mathematical constant e.

e() -> DOUBLE

z_score(x:mean:stddev:)

Computes the standard score (z-score) for x given population mean and standard deviation.

z_score(x: DOUBLE, mean: DOUBLE, stddev: DOUBLE) -> DOUBLE