Summing subtotals

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hello,

The first page of my report sums data in the detail
section in the footer page into 4 different categories. I
would like to sum those 4 categories now for a "Total"
number of everything.

The formula I am using is =Sum([Category 1]+[Category
2]....+ [Category 4])x 12)

Im using 12 to get a yearly total of monthly data Im using
but am unable to come up with a Grand Total. What am I
doing wrong?

Thanks for your help!
 
Mike,

Add a report footer (under View in report design) and
a "summing" formula there will sum everything in the
report.

HTH,

Terry
 
Back
Top