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?