Trouble with Averages
I am having some trouble getting my summary averages to work properly. I have a database to keep track of my grades in a class I teach. Each project has a record for each student with all section marks totalling to a final mark in that project for each student. Then I have a summary field that averages these final grades. When I view the averages on a per project basis everything works fine.
I have a layout linked to a table which totals all of the project marks up to a final grade for the entire class. On the layout I see each student as a row (list view) and each column is their project mark, with the final column being the total mark in the class. When I put fields in to view the average from the related tables, these fields only show the final marks of the last student in the found set rather than the average of the found set.
I have a feeling that it has something to do with the way Filemaker deals with summaries of summaries, but I'm not sure exactly what it is.