ABS

Returns the Absolute Value of a number.

Absolute Value can be thought of as "The distance from zero". Take two numbers; plus 38.52 and minus 38.52. Although they are very different numbers they are both the same distance from zero. The Absolute Value for both these numbers will be 38.52 (note no minus sign).

ABS ( <field_name or value> )

field_name or value: The numeric field or value to perform the calculation on.

Example: create a field at the ACCOUNT level that returns the absolute value of the account balance field.

ABS([Account.Acct Balance])