The ABS() formula is a mathematical function used to calculate the absolute value of a number. In other words, the ABS() function returns the positive value of a number.
Here are some examples of how the ABS() function works:
##ABS(“Number”)
-
ABS(5) returns 5 because the absolute value of 5 is 5.
- ABS(-5) returns 5 because the absolute value of -5 is 5.
- ABS(0) returns 0 because the absolute value of 0 is 0.
-
Positive Numbers: If you use the ABS() function with a positive number, it will return the same positive number.
- Negative Numbers: If you use the ABS() function with a negative number, it will return the positive value of that number. For example, ABS(-5) will return 5.
- Zero (0): If you use the ABS() function with zero, it will return zero because the absolute value of zero is still zero.
- Non-Numeric Values: If you provide a non-numeric value (e.g., text) to the ABS() function, it will result in an error.
| Source Field Value |
Destination Field Value |
| ##ABS(“5”) |
5 |
| ##ABS(“-5”) |
5 |
| ##ABS(“0”) |
0 |