Thank you for the reply and for the example. I have been trying to apply the fields and calculations to my solution.
I did not have a separate grade table. Having undertaken the relationships as noted in your sample file, the one field that is not working is the Total Number of Students Grade. Is there another function calculation that can achieve the same result?
What is the function of the _Value one? Sorry, I am not a full fledged FileMaker user. I have mostly learnt through trial and error.