Accumulated

Question

Solved5.44K viewsJune 20, 2018Formulas and Functions

0

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)
Or
Sales Accumulated=SUM(Sales Monthly:January .. Sales Monthly:Month)

Why this formula does not work?

Thanks,
Rui

score 1 · Answer 1 · 2004-07-13T01:29:13+00:00

Hello – thanks for your post:

You can accomplish this by incoporating recurrence along both the MONTH and YEAR dimension.

2 formulas are needed. One for the first 12 months, and then one ongoing. Take a look at the attached file and please post again if any questions…

Regards,

-Mike