Calculation for the next day opening stock

[tabisen1]

Dear all,

I am stuck in finding the next day opening stock. Can any one help me to do the following calculation working.

their are three table or file which I have loaded  in the QV

Calculation should

Opening stock + Production - Sales = Closing Stock

Closing Stock will be the opening stock for the next day. same formula for the next day this will go on day wise month or year.

Day end Closing Stock will be next Day opening Stock

Month end Closing Stock will be next month 1st day Opening Stock

Year end Closing Stock Will be next year 1st month 1st day Opening Stock

Result should look like this

[fvelascog72]

Can you share this data to try with it?

Or maybe a fake data with the same fields.

[tabisen1]

i have attached the file above

[fvelascog72]

Try with this one

I hope it helps

[tabisen1]

Federico,

If I load the excel file function not working lave a look.

[tabisen1]

Dear Federico,

have find out the issue why is it not working by load the data through Excel.

need urgent help regarding this can you or any one else in community who can help me out from this issue.

[fvelascog72]

Hi,

Use this:

If (OpeningQTY = '' or OpeningQTY = 0, null(), OpeningQTY)

as OpeningQTY,

Cheers

[tabisen1]

Opening stock is for the 1st day only 2nd day stock will be calculation is first day closing stock will be the opening stock for 2nd day + Receipt+issue( -ve value) equal to 2nd day close will become 3rd day opening. and so on month year ........

[fvelascog72 · Accepted solution]

Hi,

Replace this:

If (OpeningQTY = '', null(), OpeningQTY)

as OpeningQTY,

With:

If (OpeningQTY = '' or OpeningQTY = 0, null(), OpeningQTY)

as OpeningQTY,

[tabisen1]

thank you federico it works