I have a load of room records with Area and Capacity fields and summary totals (sArea and sCapacity).

I'd also like another field to summarise the ratio of sArea/sCapacity but this doesnt work. I tried average of area/capacity too. Getsummary seems to work but only for the subsummary defined in the break field.

Thanks for any help.

Edited May 12, 201015 yr by Guest

If I understand your request correctly, you need two calculation fields: one to go in the sub-summary part =

GetSummary ( sArea ; breakField ) / GetSummary ( sCapacity ; breakField )

and another for the grand total =

GetSummary ( sArea ; sArea ) / GetSummary ( sCapacity ; sCapacity )

or just =

sArea / sCapacity