ABS
Transforms numeric values into their absolute form for consistent calculations and comparisons.
Last updated
Was this helpful?
Transforms numeric values into their absolute form for consistent calculations and comparisons.
The ABS function returns the absolute value of a number, which represents the number’s magnitude without considering its sign. If the input value is negative, the function converts it to a positive number. If the value is already positive or zero, it remains unchanged. This function is commonly used in calculations where only the size of the value matters.
ABS(value)value – The number for which you want the absolute value (Required).
ABS(COLUMN1)In the example below, the Absolute Values measure is created using the ABS function to display the absolute values (without a sign) of the Actuals measure.

Last updated
Was this helpful?
Was this helpful?