Function Description
| Category | Description |
|---|---|
| Syntax | ABS(number) |
| Function | Returns the absolute value of the specified number. An absolute value is a value without a positive or negative sign. |
| Parameter | number: any real number whose absolute value you want to calculate |
| Number of Parameters | 1 |
| Parameter Type | Number |
| Return Value Type | Number |
Examples
| Formula | Result |
|---|---|
ABS(-1.5) | 1.5 |
ABS(0) | 0 |
ABS(2.5) | 2.5 |
More Examples
For example, you can use ABS to calculate the absolute value of the difference.
1
Click + Calculated Field, enter ABS(Difference), and then click OK.
2
The difference values are converted to absolute values, as shown in the following figure.
