Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have an issue on calculating inventory out value.
I have attached the excel file please find the details on it.
thanks,
You have to explain how you have calculated in excel. Otherwise there is very rare chance you will get reply..
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.
Provide this in Calculated Way in Excel..
I mean keep the formula there in excel to understand.
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.
Thank you sunny exactly you have understood what i want.
what's the solution for this in Qlik