Qlik Community

Ask a Question

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
urazbekov
Contributor
Contributor

Calculation of price with inventoring and FIFO rule

Hi everyone, 

I have number of purchased kilograms of item with different price and also I have number of sold kilograms of item with buying and selling dates  respectively. I would like to evaluate avg price per kilo on the date of discharge with the rule of First In First Out. 

Table with example attached.

Anyone knows how to calculate discharging prices in table above? I tried to use accumulation by previous dates as a part of solution, but still cannot do that task. 

Would be very appreciate for your help! 

Labels (3)
0 Replies