sum calculated fields

  • Thread starter Thread starter Matthew Loraditch
  • Start date Start date
M

Matthew Loraditch

I have a report where i calculate information using the following formula:
=IIf([Tax]=0,0,0.05*Sum([Quantity]*[Unit Price]))+Sum([Quantity]*[Unit
Price])+[Shipping Charge]
This information is grouped by it's type. I'd like to place a total for
each group and then a master total for the whole report.
I believe i've placed the field correctly in the group footer and set the
field as a running sum for the group but the number produced using the same
equation is not correct. I'm thinking i may need to Dsum something but i'm
not sure what?
Can anyone help?
Thanks
 
Matthew,
If you calculate a value "on the report", it isn't "bound" to any field,
so =Sum(MyField) won't work in your footers.
Add this field to your query behind the report
TaxCalc : =IIf([Tax]=0,0,0.05*Sum([Quantity]*[Unit
Price]))+Sum([Quantity]*[Unit Price])+[Shipping Charge]
Now place TaxCalc on the report, and...
= Sum(TaxCalc)
will work in any report footer.
hth
Al Camp
 
Back
Top