Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Averaging summary fields


Recommended Posts

Hi all, Happy New Year. Can anyone help?


I have a Summary field that is a count of appointments each of my teachers had during the term. I want the high, low and average number of these appointments. I know I can't create a Summary field to Average a Summary field - so what can I do? I tried a calculatiuon field, but it returned an incorrect average. And I don't know how I'd get a Low or High using a Caluclation field.


Thanks in advance.

Link to comment
Share on other sites

Assuming you have a Teacher table related to Appointment, use a Count(Appointment::AppointmentID) calc in Teacher to get a count of each teacher's appointments. Then sort the Teacher records by this count. The first record (or records) will be the Low, the last record (or records) will be the High. Although this may perform poorly with large record sets, I think it will be the most accurate.


"Average" has different meanings, but if you want the mean number of Appointments per Teacher, you might try a script to get the total number of records in the Appointment table (or the total for the current semester, etc.) and divide by the number of teachers.

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...

Important Information

Terms of Use