Calculate percentage for each group

  • Thread starter Thread starter Beetle
  • Start date Start date
B

Beetle

I'm working on a report that has two groups. In the detail section for
each group I would like to show the percent of the group and the
percent of the total, so the result would look something like;

Group 1 Deliveries Pickups Total % of Group % of Total
A 5 3 8 50%
32%
B 2 3 5 31%
20%
C 1 2 3 18%
12%

Group Totals: 8 8 16

Group 2 Deliveries Pickups Total % of Group % of Total
D 3 2 5 56%
20%
E 1 0 1 11%
4%
F 0 3 3 33%
12%

Group Totals: 4 5 9

Grand Totals: 12 13 25

I'm having trouble getting the group percentage to work. If I use
=([txtTotal]/[txtGroupTotal]) in an unbound text box I get a parameter
popup because there in more than one group total. I've tried a few
other methods with hidden controls, etc. but can't get anything to
work. Any Ideas?

TIA
 
Thanks Marsh. I tried that in the footer, but not in the header. I didn't
realize that made a difference. Appreciate the help.
 
Back
Top