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