Beginners Question: Summing an item in a group footer, not details

[Former Member]

I have a reoccurring problem with my reports. It is a pretty standard budget structure with a group for a department, subgroup for charge code, and items charged. Each charge code has a budget amount. It looks like this:

GH 1 Department Group
      GH 2 Charge Code
              Details Item one             Amount 1
              Details Item two             Amount 2
              Details Item three           Amount 3
             .... 
      GF 2 Charge Code             sum(Amounts)          Budget Amount
GH 1 Department Group          sum(all Amounts)      sum(Budget Amounts)

Using data to make this a little clearer... if the first charge code has a budget allocated to be 100 dollars:

Department Group 1
      Charge Code 100
              Item one             $1.00
              Item two             $2.25
              Item three           $0.75
             .... 
      Charge Code             $64.43                       $100.00
Department Group          sum(all Amounts)      sum(Budget Amounts)

This way they can see the total spent per charge code and compare it to the budget total for that code.

Here is the problem: If there are 10 items within the one charge code, the sum at the department group level winds up 10*100.00 or $1,000.

Department Group          $64.43                        $1000.00

I have no idea why it would sum the budget amount for each item. The report parameter is in the footer, not the details, but it definitely does this. Every time.

How do I make it stop?

Thanks in advance

Edited by: Angry Planet on Nov 3, 2009 3:52 AM

Edited by: Angry Planet on Nov 3, 2009 3:54 AM

[Former Member · Accepted solution]

You could use the option of running totals and evaluate on a particular field and reset the total also.

Using this option you could get your sum perfectly

[Former Member · Accepted solution]

Running totals is the answer. Thanks. I had never encountered them before, but they do just what I need.

Thanks again, and enjoy your points