Description
Calculates the difference in a value between an item and the previous one
Syntax
DECUMULATE(Number, Decumulated Dimension [, Group Metric])
-
first parameter
Number
can be a Metric or a List Property -
Decumulated Dimension
, list according to which decumulation is made, should be one of the Dimension of the first parameter -
Group Dimension
is a list that resets the decumulation
Return type
Number
Examples
Case | Results | Return Type |
| returns the monthly |
|
Use ON operator with DECUMULATE
You can use the ON operator to change the order of accumulation in the CUMULATE function. The Metric in the example below is dimensioned by Vacuum Cleaner and represents inventory:
CD004_Cumulated Inventory (Input) | |
---|---|
Vacuum Cleaner A | 102 |
Vacuum Cleaner B | 48 |
Vacuum Cleaner C | 72 |
You want to decumulate this cumulated inventory to display the real inventory. It’s important to decumulate it in the correct order, as defined by the Priority Property in the Vacuum Cleaner Dimension List. You can see this below:
If you want to decumulate in the order of the Priority property, you can use this formula: DECUMULATE(‘CDO04_Cumulated Inventory (Input)’, ‘Vacuum Cleaner’ on ‘Vacuum Cleaner’.Priority)
Remember to include the ON operator in the second argument of the function.
You can prioritize Vacuum Cleaner B with a priority of 1, which is decumulated first, maintaining the original value. Next, Vacuum Cleaner C is processed, deducting the preceding Vacuum Cleaner B's decumulated value of 48 from the original value of 72. This leaves the resulting value of 24.
Excel equivalent: None
See also: CUMULATE