B
babs
Posted this morning in reports and have not heard back - would love to get
figured out by tonight??? see below
Job # System Date Customer Code Customer Name Invoice #
Invoice Amt
80180119 7/31/2009 GARCOCONST GARCO CONSTRUCTION, INC. $14,065.00
80180119 7/31/2009 Monaco Monaco Mechanical 150294
$14,500.00
80180119 8/31/2009 GARCOCONST GARCO CONSTRUCTION, INC.
$7,313.80
80180119 8/31/2009 Monaco Monaco Mechanical 150295
$7,540.00
I have a report and I need to divide from the above data - the 2 record by
the 1 record(invoice amt) really need to get the %
change((14,500/14,065)-1)/100=3.09% - and then the same thing for the next
two records, the date and the job # match for these records so not sure if I
do a dsum???what it should look like and where on the report to put
it????-report footer?? in detail section??
thanks for helping in advance??
Barb
figured out by tonight??? see below
Job # System Date Customer Code Customer Name Invoice #
Invoice Amt
80180119 7/31/2009 GARCOCONST GARCO CONSTRUCTION, INC. $14,065.00
80180119 7/31/2009 Monaco Monaco Mechanical 150294
$14,500.00
80180119 8/31/2009 GARCOCONST GARCO CONSTRUCTION, INC.
$7,313.80
80180119 8/31/2009 Monaco Monaco Mechanical 150295
$7,540.00
I have a report and I need to divide from the above data - the 2 record by
the 1 record(invoice amt) really need to get the %
change((14,500/14,065)-1)/100=3.09% - and then the same thing for the next
two records, the date and the job # match for these records so not sure if I
do a dsum???what it should look like and where on the report to put
it????-report footer?? in detail section??
thanks for helping in advance??
Barb