0
Former Member
Nov 03, 2009 at 01:12 AM

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

21 Views

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?