Other Calculation Functions
There are other functions that can help you create complicated calculations.
Exponentiation is a mathematical operation where a number (called the base) is multiplied by itself a certain number of times. Formula -> COLUMN_NAME ** EXPONENT
The square root of a number is that factor of a number which when multiplied by itself gives the original number. Formula -> RESULT = COLUMN_NAME ** (1/2)
These define the order in which operations are carried out based on PEMDAS or BODMAS. Illustrated below are the differences in the calculation column + 10 * 5 and (column + 10) * 5
This function is already well explained in Absolute Function
This function rounds off the result to the nearest whole number.
Last updated