ABS

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.

1. Positive Numbers: If you use the ABS() function with a positive number, it will return the same positive number.
2. 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.
3. Zero (0): If you use the ABS() function with zero, it will return zero because the absolute value of zero is still zero.
4. 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