Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jayaseelan
Creator III
Creator 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,

6 Replies
MK_QSL
MVP
MVP

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

jayaseelan
Creator III
Creator III
Author

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.

MK_QSL
MVP
MVP

Provide this in Calculated Way in Excel..

I mean keep the formula there in excel to understand.

sunny_talwar

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
Creator III
Creator III
Author

Thank you sunny  exactly you have understood what i want.

contributor_H
Contributor III
Contributor III

what's the solution for this in Qlik