Multiple Record Average

[debz04]

My database is almost complete and I started working on reports. Is there a way to calculate the average of data stored in multiple records that appear in a single report? For example: There are 23 students who took the same test, and I would like them to appear in a single report (done that), and have Filemaker calculate the average score on that test for those 23 students.

[LiveOak]

Create a Summary field. We often think of Summary fields as providing the "Total of" a set of records, but other possibilities also exist, including "Average of", "Count", "Minimum", "Maximum" and "Standard Deviation".

-bd