Time Line Recurrence Formula

Question

Solved4.83K viewsJune 12, 2018Formulas and Functions

0

carlo capasso 233 April 8, 2014 0 Comments

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.

Solutions?

Thank you so much.

4 Answers

0

Product Management 62 Posted April 9, 2014 0 Comments

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.

score 0 · Answer 1 · 2014-04-09T08:45:51+00:00

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:

Regards

score 0 · Answer 2 · 2014-04-09T04:40:35+00:00

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.

score 0 · Answer 3 · 2014-04-08T17:06:57+00:00

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.

Time Line Recurrence Formula

4 Answers

Attachments

Latest Questions

Connect