ABS

Returns the absolute value of the parameter.

AVG

Returns the average of a set of numbers from a variable number of parameters.

IF

Allows for conditional logic to determine if a calculation will execute based on the criteria in the statement.

MAX

Returns the maximum number from a set of numbers (from a variable number of parameters)

MIN

Returns the minimum number from a set of numbers (from a variable number of parameters)

MOD

Returns the modulus (integer remainder) resulting from the division of two numbers.

ROUND

Rounds to the nearest whole number.

SQRT

Returns the square root of a value or numeric parameter.

SIGN

Returns 1 if the parameter is positive, -1 otherwise

SUM

Takes a variable number of parameters and provides a sum total.

TRIM

Truncates the decimal places of a parameter value.