Other Calculation Functions

There are other functions that can help you create complicated calculations.

Other calculation functions

Exponentiation ( X^2 )

Exponentiation is a mathematical operation where a number (called the base) is multiplied by itself a certain number of times. Formula -> COLUMN_NAME ** EXPONENT

Exponentiation

Square Root ( √ )

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)

Square root of a field

Brackets ()

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

column + 10 *5

(column + 10) * 5

ABS (Absolute)

This function is already well explained in Absolute Function

Round

This function rounds off the result to the nearest whole number.

Rounding off