The Abs function returns the absolute, non-negative value of a number.

Syntax

Abs(number)

Function argument:

  • number (required) - The number or column of numbers that is being evaluated.

Example

A Distance Covered column that contains negative values can be corrected to hold only positive values.

Abs(\[Distance Covered\])

With Abs function, all the values in the Distance Covered column will be converted to positive values.

Abs_Example.png