ABS
The ABS function returns the absolute value of a number (i.e) a number without its sign.
Syntax
ABS(value) - > number
Arguments
| Arguments | Datatype | Description |
|---|---|---|
value | Number/Node reference | The node or the number for which you want the absolute of. |
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.
| Parameter | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 |
|---|---|---|---|---|---|
Demand | 110 | 95 | 75 | 78 | 0 |
Inventory | 85 | 70 | 100 | 80 | 25 |
To achieve this, the following formula should be written in the [Absolute Difference] node:
ABS([Demand]-[Inventory])
Result
Absolute Difference | 25 | 25 | 25 | 2 | 25 |
Note
If ABS is not used the difference between values will be as follows:
Absolute Difference | 25 | 25 | -25 | -2 | -25 |
Last updated