DECUMULATE function

  • 21 December 2021
  • 2 replies
  • 478 views
Samya Barkaoui
Rank
Userlevel 4
Badge

 

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

 

Excel equivalent: None

See also: CUMULATE

Samya
This topic has been closed for comments

2 replies

A
Rank

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

Chris
Rank
Userlevel 6
Badge +6

@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. 

Chris

Ask your question here!

Terms & ConditionsCookie settings