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 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.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas