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