I have a report that is grouped by fund (GH1), then division (GH2), with columns for "Budget" and "Expenses to Date" (and some other).  I want to find the percentage of expenses compared to budget for each division.

 

The divisions are totaled in GF1 and I can get the percentage to work for that; however, I can't figure out how to get the percentages for each individual division. 

 

I have tried every combination of GH1 and GH2 but cannot figure it out.  I am using

 

if {Whole} = 0 then 0 else

{Part} % {Whole}

 

With the whole being Budget and part being expenses to date.

 

Any ideas?

 

 

            Dept                    Budget                YTD Trans            % Spent

(GH2)  Dept 1                 12321                   5000

(GH2)  Dept 2                 65646                   7000

(GH2)  Dept 3                 56548                   4564

(GF1)   Total                   654311                 12131                    20%

 

The Departments are a sum of each month's transactions and are grouped by Fund then Dept.  The total % spent is correct, I'm having trouble getting the dept %.

 

Thanks

 

Administration

   Human Resources

   Finance

   Accounting

 

... with all the departments grouped with their respective division.  So the HR, Finance and Accounting are a group within the Admin group, etc.  That's what's causing me the problem.  If I don't group HR, Finance and Accounting within Admin, I can get the numbers just fine.  But these departments must be grouped within their division.