Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jayaseelan
Contributor III

Inventory FIFO Calculation

Hi everyone,

I have an issue on calculating inventory out value.

I have attached the excel file please find the details on it.

thanks,

5 Replies

Re: Inventory FIFO Calculation

You have to explain how you have calculated in excel. Otherwise there is very rare chance you will get reply..

jayaseelan
Contributor III

Re: Inventory FIFO Calculation

Thanks for your reply,

I need to calculate first in quantity values should be carry to first quantity values, if i buy 5 watches 10rs as a unit price of watch, then i sold 3 watches that out value should be from buy value.

Re: Inventory FIFO Calculation

Provide this in Calculated Way in Excel..

I mean keep the formula there in excel to understand.

MVP
MVP

Re: Inventory FIFO Calculation

Manish -

I have added the FIFO logic in the Excel. I think the dates are kind of misleading here, but I think you will see the logic. BTW if you don't already know, FIFO is First In First Out. The inventory which came in first needs to be sold first before we sell the newer inventory.

jayaseelan
Contributor III

Re: Inventory FIFO Calculation

Thank you sunny  exactly you have understood what i want.