Abs
Purpose
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
FileMaker Pro 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.
Examples
Abs(-123) returns 123.
Abs(PriceDifference) returns the positive value of the number in the PriceDifference field.
Abs(TargetDate - ActualDate) returns a positive value for the number of days difference between the values in TargetDate and ActualDate.
Related topics