DECUMULATE function

  • 21 December 2021
  • 2 replies
  • 150 views

Userlevel 3
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


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 5
Badge +5

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