b*****o
发帖数: 284 | 1 Suppose I have a table taking care of incoming:
Date amount unit_price($)
01/01/05 5 7
01/02/05 4 2
01/03/05 6 3
01/04/05 3 6
01/05/05 8 1
Also have a table taking care of outgoing:
Date amount cost($)
01/01/05 2
01/02/05 7
01/03/05 6
01/04/05 3
01/05/05 4
I would like to define the outgoing cost using "First in First out", so the
cost should be calculated as:
Date amount cost($)
01/01/05 2 2*$7 | w*r
发帖数: 2421 | 2 I am lost, what is the calculation mean?
what is the def of FIFO here in your case?
【在 b*****o 的大作中提到】
: Suppose I have a table taking care of incoming:
: Date amount unit_price($)
: 01/01/05 5 7
: 01/02/05 4 2
: 01/03/05 6 3
: 01/04/05 3 6
: 01/05/05 8 1
: Also have a table taking care of outgoing:
: Date amount cost($)
: 01/01/05 2
|
|
