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 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas
Was this topic helpful? Send feedback.