ABS

The ABS function returns the absolute value of a number (i.e) a number without its sign.

Syntax

ABS(value) - > number

Arguments

Example

In the below table, data of demand and inventory are given. Consider a scenario where you want to calculate the absolute difference between demand and inventory.

To achieve this, the following formula should be written in the [Absolute Difference] node:

ABS([Demand]-[Inventory])

Result

Note

If ABS is not used the difference between values will be as follows:

Last updated