Totals

[Ted]

I have a report that I can't seem to get the proper totals
to calculate. In the report I have it grouped by "Age".
There are 4 possible ages: Current - Over 30 - Over 60 -
Over 90. I want the total of each group. I have put a the
same field in the detail and group footer sections.

If I set running sum to over group then I get the correct
total on the last detail line, however the same field (set
to over group) in the group footer only displays the total
for the first detail line. The second group footer
displays the first group value + the first detail entry of
the 2nd group.

I doubt that I am explaining this very well so maybe my
example below will be better. I am trying to get the 1st
group footer to display the total of all of the detail in
that group and the next to display the total of all of the
detail in the second group and so on.

What am I missing?

Example:
[Group Header]
Current

[Detail]
A1 100.00 100.00
A2 50.00 150.00
A3 75.00 225.00

[Group Footer]
Current Total: 100.00

[Group Header]
Over 30

[Detail]
B1 200.00 200.00
B2 150.00 350.00
B3 500.00 850.00

[Group Footer]
Over 30 Total: 300.00

Thanks for any guidance!

 

[Roxie Aho]

In the Group Footer field make it =sum(fieldname) of the
field you want to total. You might also have to adjust
the running sum. I've never used it so don't know what
effect it will have on your report.
Roxie Aho
(e-mail address removed)

 

[Rolls]

Doesn't look like you want a running total, just a subtotal at each break
plus a grand total. The summary band should have a formula
=sum([fieldname]) for all subtotals no matter how many layers (up to 10) you
have.