anybody?
"Dimitri Kryukov" wrote:
This is an example, hope it shows up correctly on the web
this is the Database:
Date Name P&L
03-Jan AMENP $15,845.00
04-Feb AMEN $32,485.00
05-Feb AMENP $34,654.00
03-Mar AMEN $18,948.00
this is the Table (=dsum(Database,3, Criteria):
$101,932.00 <Feb-05 <Mar-05 <Apr-05
AMEN $15,845.00 $82,984.00 $101,932.00
AMENP $15,845.00 $50,499.00 $50,499.00
this is the net monthly P&L (Month+1 - Month)
Jan-05 Feb-05 Mar-05
AMEN $15,845.00 $67,139.00 $18,948.00
AMENP $15,845.00 $34,654.00 $-
pls note how AMEN = AMEN + AMENP every month while AMENP is calculated
correctly
|