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

[former_member426266]

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.

Ram.

[amitrathi239]

try with runningsum() function.