Abs
Returns the absolute value of a number.
Format
Abs ( number )
Parameters
number - any numeric expression or field containing a numeric expression
Data type returned
number, time
Originated in version
6.0 or earlier
Description
The absolute value of a number is positive. For example, if a negative number appears in a field, the Abs function removes the minus sign and changes it to a positive value.
Example 1
Abs(-123) returns 123.
Example 2
Abs(PriceDifference) returns the positive value of the number in the PriceDifference field.
Example 3
Abs(TargetDate - ActualDate) returns a positive value for the number of days difference between the values in TargetDate and ActualDate.