Skip to Content
avatar image
Former Member

cumulative value Calculation

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 22, 2012 at 03:23 PM

    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

    Add comment
    10|10000 characters needed characters exceeded