Links

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