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 ?
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
@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
Test - Please Ignore
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
