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
@rob_marshall I feel like you would be able to answer my question, and if you can't then no one can. My question is - using selective access on a hierarchy level I want to be able to look up the user that has access to a particular level within the hierarchy so that I can create a standardized e-mail using the mailto…
I have difficulty with “Custom views” in Activities 13.6.5 and 13.9.3 where I select Custom View but cannot Filter Time Dimension. The instruction is "Filter: Time - show only Forecast Months" Could anyone please help on this issue.
Hi! I'm currently trying to set up an example for the forecaster and I'm running into various issues. At first (and I managed to resolve it by now) my data collection creation failed without any error messages. Next, after I managed to create it, my forecaster model is stuck on status 'creating' for 1.5 hours already. Is…
