how to calculate opening stock

[paulwalker]

Hi  All,

I have a scenario

Current month opening stock would be Total_stock for max of  year-month

i didn't understand this requirement

please anyone can explain meee

Thanks in Advance..

[fred_s]

Hi Paul,

Can you try this one

[fred_s]

After loading your data, I've loaded your data again with an order by Year-Month and used the previous() function to get the lastmonth stock, saved as new field "Ostock".