DECUMULATE function

  • 21 December 2021
  • 2 replies
  • 825 views

Userlevel 5
Badge +3

 

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

DECUMULATE('YTD Quantity Sold', month)

returns the monthly Quantity Sold from a YTD data.

number

 

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


This topic has been closed for comments

2 replies

Can this be used to create Cash flow statement - BS account movements - closing - opening balances ?

Userlevel 7
Badge +13

@Aayush Batra   There are a lot of factors that could come into what function you use.  Check out this article  and then ask this as a question using the + Create Topic button.  The more detail you give, the better chance we can help you out.