Reference > Functions reference > Number functions > Abs

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

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.

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.

Abs