Highlighted
Occasional Contributor

CUMULATE WITH LISTS WITHOUT CUMULATING WITH TIME

Hi,

I am having a module  having a list dimension and weekly time scale. I want to cumulate the values of a line item w.r.t list items without cumulating it w.r.t  time. Is there any way to do so ?

3 REPLIES 3
Highlighted
Master Anaplanner/Community Boss

Re: CUMULATE WITH LISTS WITHOUT CUMULATING WITH TIME

Hi,

 

Try this,

We have the option to cumulate the value based on the list.

 

Formula = CUMULATE(VALUE, FALSE, 'Country')

 

Check this link,

https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/CUMULATE.html 

Highlighted
Community Boss

Re: CUMULATE WITH LISTS WITHOUT CUMULATING WITH TIME

RANKCUMULATE() also gives you some options
Nathan Rudman
Anaplan Model Builder
Highlighted
Community Boss

Re: CUMULATE WITH LISTS WITHOUT CUMULATING WITH TIME

@RahulSahoo 

 

Both the ways will work that @VIGNESH.M  and @nathan_rudman  has suggested. However one thing with cumulate function is that if used against a named list it will follow the original display order and not the reordered list(if that happens later)

 

Thanks,

Misbah