Time Line Recurrence Formula

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
Solved2.89K viewsFormulas and Functions

Hi all,
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.

Selected answer as best

I see your point in regards to the yellow sign being a bit startling but the formulas should still work. The message is more intended to be a notification that the formula is not using the Timeline logic which is OK. The formula should still work… let us know if not.

Selected answer as best

Thank you all.
I had tried with both the solutions provided by Mike and Sau but, as the formula bar give me the yellow sign, I thought that it could not be used.

I rewrote the formulas and the results are ok but the “yellow sign” is still there:confused:



Hi all.

I also met this problem when I tested QM5.1 in January 2014.
Empirically I found a solution by using the one formula. In your case the formula looks like this:

[SIZE=”2″][font=”Lucida Console”]Cumulated Costs = Total Cost:Month + Cumulated Costs:Month[~PREV][b:2wql22dd]:Year[THIS][/b:2wql22dd][/font][/SIZE]

I hope, it will help you.


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.