Reference > Functions reference > Number functions > Abs


Returns the absolute value of a number.




number - any numeric expression or field containing a numeric expression

Data type returned 

number, time

Originated in 

FileMaker Pro 6.0 or earlier


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.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas