Numeric functions relate to mathematical operations. Numeric functions work across all calculations (regular, text, option, table, historical) as long as the arguments for the functions are numeric.

• abs: returns the absolute value of a number
• ceiling: rounds a number up
• floor: rounds a number down
• gt: determines if the first value is greater than the second value
• gteq: determines if the first value is greater than or equal to the second value
• ln: calculates the natural logarithm of a number
• log: calculates the logarithm (base 10) of a number
• lt: calculates if the first value is less than the second value
• lteq; calculates if the first value is less than or equal to the second value
• mod: calculates the remainder when dividing one number by another
• pow: raises the first value to the power of the second value
• safe: returns a number value or zero. Useful when fields that are part of a calculation might be empty.
• sqrt: calculates the square root of a value
• sum: calculates the sum of all values
• trunc: returns the closest whole number