Skip to Content
0

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

Jun 23, 2017 at 03:03 AM

41

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Jun 23, 2017 at 10:12 AM
0

try with runningsum() function.

Share
10 |10000 characters needed characters left characters exceeded