Last month of data

[prma7799]

Dear All,

I have two column one is Opening stk second is closing stock I have query that is my opening stk is previous month closing stock

Now my opening stk is 0 and closing stk is 500

How to achieve 500 as my next month oping stk

here are the script :

OPENING STK:

SUM({$<[Flag]={3}>}QTY)

Closing Stk :

([OPENING STK] + [TOTAL RECEIPT] ) - [TOTAL ISSUE])

Thanks

[MK_QSL]

Provide sample data or sample app to work