Hi Bob,

I have another situation where the calculated totals at the highest summary level dont jive with the calculated totals on the drill downl levels. Please see attached. In this situation, the AVG Percent calculated in the bottom half is correct, it is the average of the Percentages listed. But in the top half, the Percentages listed are not correct. E.g. for Berkshire 42/696 <> 98.5. I cant figure out what this is doing at this level.

I am also unable to calculate the percentage itself using a formula...here is what I am using, but it returns 0.

[[[J2.TOTAL@MAX]-[COUNT@COU]]/[J2.TOTAL@MAX]]*100

Any help or explanation you can provide would be appreciated. Thanks.

Cynthia