ABS
Last updated
Was this helpful?
The ABS function returns the absolute value of a number (i.e) a number without its sign.
ABS(value) - > number
value
Number/Node reference
The node or the number for which you want the absolute of.
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.
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])
Absolute Difference
25
25
25
2
25
If ABS is not used the difference between values will be as follows:
Absolute Difference
25
25
-25
-2
-25
Last updated
Was this helpful?
Was this helpful?