AnsweredAssumed Answered

Averaging values from another table

Question asked by FileMakerNovice on Dec 23, 2011
Latest reply on Dec 23, 2011 by philmodjunk


Averaging values from another table



I am new to Filemaker and just can't seem to find how to do this...

I'll simplify it a bit.  I have two tables, one called Students, one called Grades.  The Students table has a Student ID and Student name.  The Grades table has the Student ID field and a Grade field.  I want to show in the Student layout an average of all the grades. Students is currently a one to many relationship with Grades.

I added a portal and it shows the correct values but I want an average of these values.  I attempted to add a new field in Students with the calculated value of =average(Grades::Grade) but it displays nothing.

I feel like I'm missing something simple.  How do I create an average of these grades on another table?

Thanks in advance.