Function: Abs

Description

Returns the absolute value of a number.

Syntax

Abs(number)

Arguments

Number can be a constant, a numeric field, or an expression that results in a number. It can also be a function that returns a number.

Return value

This function returns a positive number.

Calculated field example

If the Balance field contained the value of -159.95, the following calculated field expression would return the number 159.95: Abs(Balance)

Filter/Find example

Records with a Balance field value of -159.95 or 227.00 can be selected or found using the expression: Abs(Balance)>100.00