Inventory - Closing Stock Calculation Day by day

[kalyandg]

Hi all,

I have a issue in calculating stock, my requirement is that i need to calculate a stock(yesterday's closing stock, but from the beginning of the date(for example if i have data from 2009, it needs to calculate the stock from 01/04/2009 to 28/05/2013....it should show upto date)).

I am in need of the expression to calculate the above mentioned conditional stock.

Thank You in advance.

[kalyandg]

hi

please reply anyone,,,,urgent pls....

help me

[rustyfishbones · Accepted solution]

you could try this

SUM({<Date = {"<=$(=DATE(MIN(Date)))>=$(=DATE(MAX(Date)-1))"}>} Stock

or

SUM({<Date = {"<=$(=DATE(MIN(Date)))>=$(=DATE(TODAY()-1))"}>} Stock

or chgeck out these videos on YouTube

https://www.youtube.com/playlist?list=PLCS95xQod55X286jtdiQF5FWjevJuNysW

[kalyandg]

hi alan,

thanks for your reply and help with those videos.

it works.

Thanks,

Kalyan