DECUMULATE function

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

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:

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