B
babs
Here is a sample of what my report looks like:
Customer Code Customer Name Invoice Number Invoice Amount1
Job# 80180119
Date: 7/31/2009
GARCOCONST GARCO CONSTRUCTION, INC. $14,065.00
Monaco Monaco Mechanical 150294 $14,500.00
Date: 8/31/2009
GARCOCONS GARCO CONSTRUCTION, INC. $7,313.80
Monaco Monaco Mechanical 150295 $7,540.00
I am trying to calculate a % change betweem the 1st two records ex. 3% and
the same for the last two records not sure how to do this calculation or
where - in excel just take ((14064/14500)-1) * 100 = 3.09% the record that I
want the % change in has same date and Job# - the one set of records do not
have an invoice #.
any ideas - where to put the calculations on the report????
what am I misssing??Thanks,
Barb
Customer Code Customer Name Invoice Number Invoice Amount1
Job# 80180119
Date: 7/31/2009
GARCOCONST GARCO CONSTRUCTION, INC. $14,065.00
Monaco Monaco Mechanical 150294 $14,500.00
Date: 8/31/2009
GARCOCONS GARCO CONSTRUCTION, INC. $7,313.80
Monaco Monaco Mechanical 150295 $7,540.00
I am trying to calculate a % change betweem the 1st two records ex. 3% and
the same for the last two records not sure how to do this calculation or
where - in excel just take ((14064/14500)-1) * 100 = 3.09% the record that I
want the % change in has same date and Job# - the one set of records do not
have an invoice #.
any ideas - where to put the calculations on the report????
what am I misssing??Thanks,
Barb