I am sending an example of a formula that I think that should work on the Quantrix, but I cannot put it to work.
The objective is to accumulate values. The user inputs the Sales Monthly and the systems should return the Accumulated.
Sales Accumulated:Month=SUM(Sales Monthly:January .. Sales Monthly:Month)
Sales Accumulated=SUM(Sales Monthly:January .. Sales Monthly:Month)
Why this formula does not work?
I’ve added another twist to this topic of “accumulated” formulas – see the attached model.
What I am trying to accomplish is a forecast of “recognized” monthly revenue. Monthly Sales would be recognized over 12 months. So, month #3 would have to sum 1/12 of months 1, 2 and 3. The problem is how to restrict this accumulation to only the previous 12 months.
Thanks for the help!
I have attached a second version of the file you submitted. You need to create an additional formula to accomplish this. The formula establishes a link between December of the PREVious year and January of THIS year.
That being said – the formula you created attempts to establish this year relationship in the same formula as the month summation formula – an interesting concept. I will analyze further to see if in future versions we can acommodate something like this.
You can accomplish this by using recurrence (e.g., [THIS], [PREV]) in your formula.
Here are a couple examples:
Sales Accumulated:Month[THIS] = Sales Accumulated:Month[PREV] + Sales Monthly:Month[THIS]
Sales Accumulated:Month[THIS] = sum(Sales Monthly:Month[FIRST]..Sales Monthly:Month[THIS])
Please try this and let us know if we can help further.