AnsweredAssumed Answered

Weighted Average

Question asked by FileMakerHelp2015 on Jul 30, 2015
Latest reply on Jul 31, 2015 by philmodjunk


Weighted Average


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!