AnsweredAssumed Answered

I am stuck with an averaging challenge.  I need to average certain records from a related table.

Question asked by chris.nelson on Nov 25, 2016
Latest reply on Nov 28, 2016 by beverly

Good Afternoon.

 

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.

Chris

 

Outcomes