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