MATH Functions

All functions > MATH

All functions in the MATH category.

Arithmetic

Function	Description
ADD	Returns the sum of two quantities, numbers, dates/timestamps or intervals.
SUBTRACT	Returns the result of the subtraction of the second number from the first.
MULTIPLY	Returns the product of two numbers.
DIVIDE	Returns the result of the division of the first number by the second as a double.
TRY_DIVIDE	Returns the result of the division of the first number by the second as a double. Returns NULL if...
DIVIDE_TYPE	Returns the result of the division of the first number by the second, preserving the type of the...
TRY_DIVIDE_TYPE	Returns the result of the division of the first number by the second, preserving the type of the...
MODULO	Returns the remainder after dividing the first number by the second (modulo operation).

Rounding

Function	Description
ROUND	Returns the number rounded to the nearest integer or to a specified number of decimal places.
TRUNCATE	Returns the integer part of a number by truncating the fractional part.
FLOOR	Rounds a number down to the nearest integer (floor function).
CEIL	Returns the number rounded up to the nearest integer (ceiling function).

Sign And Absolute

Function	Description
ABS	Returns the absolute value of a number.
SIGN	Returns the sign of a number: -1 for negative, 0 for zero, and 1 for positive.

Exponential

Function	Description
POW	Returns the value of a number raised to the power of another number.
SQRT	Returns the square root of a number.
CBRT	Returns the cube root of a number.
EXP	Returns e raised to the power of the given number (exponential function).
LN	Returns the natural logarithm (base e) of a number.
LOG	Returns the logarithm of a number to a specified base.

Trigonometric

Function	Description
COS	Returns the cosine of an angle in radians.
SIN	Returns the sine of an angle in radians.
TAN	Returns the tangent of an angle in radians.
ACOS	Returns the arccosine (inverse cosine) of a number in radians.
ASIN	Returns the arcsine (inverse sine) of a number in radians.
ATAN	Returns the arctangent (inverse tangent) of a number in radians.
ATAN2	Returns the arctangent of y/x, using the signs to determine the quadrant.

Hyperbolic

Function	Description
COSH	Returns the hyperbolic cosine of a number.
SINH	Returns the hyperbolic sine of a number.
TANH	Returns the hyperbolic tangent of a number.

Angle Conversion

Function	Description
DEGREES	Returns the angle in degrees for the given angle in radians.
RADIANS	Returns the angle in radians for the given angle in degrees.

Base Conversion

Function	Description
FROM_BASE	Returns the decimal (base 10) equivalent of a number from a specified base.
TO_BASE	Returns the string representation of a decimal number in a specified base.

Constant

Function	Description
E	Returns the mathematical constant e (Euler's number).
PI	Returns the mathematical constant π (pi).
INFINITY	Returns the floating-point representation of positive infinity.
NAN	Returns the floating-point representation of NaN (Not a Number).

Validation Math

Function	Description
IS_FINITE	Returns TRUE if a number is finite (not infinite and not NaN).
IS_INFINITE	Returns TRUE if a number is infinite (positive or negative infinity).
IS_NAN	Returns TRUE if a value is NaN (Not a Number).

Bucketing

Function	Description
WIDTH_BUCKET_REGULAR	Returns the bucket number for a value in equally-spaced buckets within a range.
WIDTH_BUCKET	Returns the bucket number for a value in a histogram with custom bin boundaries.

---

Summary

• Functions in MATH: 43

This documentation is automatically generated from the FeatureMesh registry.