AnsweredAssumed Answered

Averaging values from another table

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

Title

Averaging values from another table

Post

Hello,

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.

Outcomes