I’m using the new time line category but I’ve a problem with the recurrence formula.
FORMULA: Cumulated Costs=”Total Cost:Month[THIS]+Cumulated Costs:Month[PREV]”
In this way QM calculates the progression also in January of the next year but, as it’s not a cash flow but a sum of annual costs, it would stop in december.
Thank you so much.
Hi – this is a good question.
I think you would want to do something like this:
Cumulated Costs = Total Cost:Month[THIS] + Cumulated Costs:Month[PREV] skip January
This will give you a message that the formula cannot use the new timeline ranges… and that is OK in this case.
Then you could write a formula for January like:
Cumulated Costs:January = Total Cost:January
I attached a demonstration model as well.