I have a database with two tables. One for Students (name, phone, address, etc) and one for Tests.
The main screen is the Student table information. I have a portal on that screen to show the test results. I have used an average calculation to get the averages. It worked great for the first year. But now, I would like to see each year's averages. (see below)
I have been trying to do a calculation that says If certain year then average. But I can't get it to work with the related records
Is there a calculation I can do to show the "Summary by Year" averages below?
Or is there a way to have another portal that shows Year and average?
I can't get my head around the correct approach so my experimenting has been frustrating.
Thanks for any feedback.