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