6 Replies Latest reply on Dec 23, 2011 11:24 AM by philmodjunk

    Averaging values from another table



      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.