cumulative value Calculation

[Former Member]

Hi,

I have a requirement to create a macro for cumulative plan calculation in weekly buckets & it need to change in the begining of the next year wkly buckets. pls help me out.

thanks,

rajeev

[rajkj · Accepted solution]

Hi Rajeev,

Here is a screenshot with a simple macro that performs cumulative sum.

e.g.

Element	Period 1	Period 2	Period 3	Period 4	Period 5	Period 6
Row 1	5	6	5	10	12	8
Cum. Values Row	5	11	16	26	38	46

Pay attention to the date fields and the highlighted sections. You need to fix the starting bucket and "To" field should be relative to the current time bucket. If you need any further restrictions for example, only non-zero elements are to be considered, you can enhance the macro by implementing the required logic.

Thanks,

Rajesh