Percent Problem In Report

[Mike Hughes]

My report lists three regions of the country.
Each region has 10 offices
for each region I have a TOTAL CASES field and a TOTAL PAYING field and then I have a caculated field showing the % of the cases which are paying.

next I have a SUM for each region showing the TOTAL CASES =Sum([TOTAL CASES]) and TOTAL PAYING =Sum([PAYING CASES]) cases for all offices in that region. Now I want to have the % of paying cases for these sums and I'm having problems.
This is what I thought it would be, but it doesn't come out correctly:

=SUM (Sum([PAYING CASES])) / (Sum([TOTAL CASES]))

I get the error
"cannot have aggregate function in expression
(SUM (Sum([PAYING CASES]))

Any ideas what I'm doing wrong

 

[GumbyD]

It looks to me like you have an extra SUM in your expression. The the following:

=(Sum([PAYING CASES])) / (Sum([TOTAL CASES]))

That should work. If it does not try naming the other two sum fields that you have already created and then doing the division with the two field names (ex. =SumPayCases/SumTotalCases)

Good luck!

GumbyD

 

[Mike Hughes]

Got it! Thanks Mike