Math Functions
ADD(col1, col2, col3...) Sum of at least two values
SUB(col1, col2) Difference between two values
MULT(col1, col2, col3...) Product of at least two values
DIV(col1, col2) Quotient of two values
MOD(col1, col2) Modulo of two values
ABS(col1) Absolute of a value
CEIL(col1) Rounded up to the nearest integer
FLOOR(col1) Rounded down to the nearest integer
EXP(col1) Euler’s number(e) raised to the power of col.
LN(col1) Natural log of value
SQRT(col1) Square root of a value
ROUNDDECIMAL(col1, col2) Rounds value to a specified number of decimal places
Last updated
Was this helpful?