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.