Mathematical functions

This section describes the following mathematical functions:

• ABS: Computes the absolute value of a number.

• CBRT: Computes the cube root of a number.

• CEIL: Rounds a number up to the nearest integer.

• CEILING: Rounds a number up to the nearest integer.

• DEGREES: Converts the specified radians to degrees

• EXP: Computes Euler’s number raised to a certain power.

• FLOOR: Rounds a number down to the nearest integer.

• GET_SHARD_NUMBER: gets the shard number of the Output/Lookup Table

• LN: Returns the natural logarithm of a number.

• LOG: Returns the logarithm of n, where n is greater than 0, with the specified base.

• LOG2: Returns the base 2 logarithm of x.

• LOG10: Returns the base 10 logarithm of x.

• MOD: Returns the modulus (remainder) of one number divided by another.

• MODULO: Returns the remainder of the first number divided by the second.

• POW: Raises one number to the power of another.

• POWER: Raises one number to the power of another.

• RADIANS: Converts an angle in degrees to radians.

• RECIPROCAL: Returns the reciprocal of the value (¹/ₓ).

• ROUND: Rounds a number to the nearest integer or to a specified number of decimal places.

• SIGN: Returns the signum function of a number.

• SORT_VALUES: Returns the values sorted in numerical order

• SQRT: Computes the square root of a number.

• TRUNCATE: Returns a number truncated to an integer or to a specified number of decimal places

• RAND: Returns a pseudo-random value in the range 0.0 <= x < 1.0

• RANDOM: Returns a pseudo-random value in the range 0.0 <= x < 1.0