Skip to Content

How to carry forward the previous week values to next week for dynamic calculation in BO-WEBI report

Hi Gurus,

I have a below requirement .Can any of you please help me to achieve this

1st week = Initial stock + Receipts+Issues - this will give Total available stock

2nd week = Total available stock+Receipts+Issue = Total available stock for 2nd week

3rd week = Total available stock of 2nd week + receipts+issues = Total available stock for 3rd week............

53rd week = Total available stock for 52nd week+receipts+issues=Total available stock for 53rd week.

MaterialCalweek1st week2nd week3rd week4th weekInitiaal stock5005005005001236Receipts3050040Issues-40-25-20-20Total available490515495515

2nd WK/Total available = Initial Total Available + 2nd WK/Receipts + 2nd WK/ISSUES

Will be appreciated.


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 23, 2017 at 10:12 AM

    try with runningsum() function.

    Add comment
    10|10000 characters needed characters exceeded