Mathematical
This section describes the following mathematical functions:
| Function | Description |
|---|---|
| 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 | Returns the shard number of the output/lookup table |
| LN | Returns the natural logarithm of a number |
| LOG | Return the logarithm of x to the given 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 |
| 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 |
| 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 |