using the cumulate function
Hi all,
I am trying to use the CUMULATE function to cumulate actuals (number formatted line item) over a subset of periods 'SS Periods Current year' (a subset of custom list, not Anaplan time).
I first thought that I could not cumulate because I was using a subset, but even replacing the subset with the full list did not fix the issue.
My formula is simple:
and the setup of my model only has 3 dimensions: the subset of periods, a subset which holds some sales accounts and then my line items: one of which is actuals (has data) and the other one I am now trying to calculate: cumulative actuals.
What am I doing wrong?
Best Answers

You forgot boolean as the second argument
try to use CUMULATE(Actuals, FALSE, 'SS Periods Current year')
1 
thanks a lot for your quick reaction, it works!
and thx for sharing the post
0
Answers

Check out my article about the new feature to search formula syntax within modeling experience:
https://www.linkedin.com/posts/kirillkuznetsov31b4a382_anaplannewfeaturenmxactivity7179394367797768193QQ_5?utm_source=share&utm_medium=member_desktop
0 
@LouiseBourgonjon  The syntax which you have used is wrong. It should take three parameters as below:
CUMULATE(Actuals,FALSE,SS Periods Current Year) , where FALSE(boolean) is basically given to reset the cumulation of values.
0