Hello FileMaker Forum,
I'm a HS teacher and am building a gradebook using FileMaker Pro 14, and I'm wondering how to do a weighted average of fields within a single record.
For instance, if Student 1 has several fields devoted to test scores (Test 1, Test 2, Test 3, etc.), is there e.g. a way to create a calculated field called "Tests" in which Test 1 is weighted at 30%, Test 2 is weighted at 50%, and so on?
A summary field does not appear to be the solution, since such a field averages data across records (or in my case, students), vs. dealing with averages from a single record (i.e. student).
Thanks for any guidance!