How to get the stock value from previous row

[eddykwan_]

Hi Everyone,

Please help me to find the formula script based on previous row.

Now I want to calculate the stock for all the months and the formula is :

((currentMonthProduction * Previous month stock) + (current month Sell )) / (Previous month production - current month production)

Let me give an example of how the data is

Please help me to write this script?

Thank you

[eddykwan_]

Hi Jmartineze,

Thanks for your reply, but Previous function only show value in 1 row.

another row is show null value.