ABS

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.

Syntax

ABS(value)

Arguments

value – The number for which you want the absolute value (Required).

Example

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.

Applying ABS function

Excel equivalent

ABS