ABS function
This topic describes the formula syntax and usage of the ABS function in the Data Quality Execute Formula transform.
Description
Returns the absolute value of a number.
Syntax
ABS(number)The ABS function syntax has the following arguments.
- number Required. The real number of which you want the absolute value.
Example
Data: -4 in the Negatives field.
| Formula | Description | Result |
|---|---|---|
ABS([Negatives]) |
Absolute value of -4 | 4 |
ABS([Negatives] * 2) |
Absolute value of -8 | 8 |