calculation on a summary

[Aussie John]

I have a couple of summary fields calculating in a subsummary part, but when I do another calculation on the two summaries they only find the answer for the grand summary.

eg i want to calculate the ratio of room capacity to room size sorted by the subsummary of "Faculty". Each room has its own ratio but an average of those ratio doesnt give the right answer.

thanks

Edited June 10, 2008 by Guest

[comment]

Two options:

1. A calculation field =

GetSummary ( sTotalRoomCapacity ; Faculty ) / GetSummary ( sTotalRoomSize ; Faculty )

2. A summary field defined as Average of Ratio, weighted by RoomSize.