Rolling Balance

[jli87]

Header 1	Header 2	Header 3	Header 4	Header 5	Header 6
Product	Date	Order Qty	Begin Inventory	Adjusted Inventory
Apple	10/08/18	20	500	60
Apple	10/15/18	30		45
Apple	10/22/18	5		30
Orange	10/08/18	25	600	35
Orange	10/15/18	15		40
Banana	10/08/18	35	650	25
Banana	10/15/18	60		20

I am having issues with creating a table with beginning inventory for each week. I have a table similar to the one above with only a specific week with a beginning inventory. I need to factor in the order qty and adjusted inventory for each week to get the beginning inventory for the next week like something on the bottom. Thank you in advance.

Header 1	Header 2	Header 3	Header 4	Header 5
Product	Date	Order Qty	Begin Inventory	Adjusted Inventory
Apple	10/08/18	20	500	60
Apple	10/15/18	30	540	45
Apple	10/22/18	5	555	30
Orange	10/08/18	25	600	35
Orange	10/15/18	15	610	40
Banana	10/08/18	35	650	25
Banana	10/15/18	60	640	20

[uacg0009]

Hi Jia Li,

I think below is what you want, please see the attachment, thanks.

Aiolos Zhao

[jli87]

Yes, that's how I want it to look but can this be done from the script end?

[uacg0009 · Accepted solution]

Yes,you can try to use peek() function to change the above() function in back-end.

the sort is important.

Aiolos