2 Replies Latest reply: Jan 23, 2017 5:39 PM by Michael Andrews RSS

    Average a Sum of Child Records

    Michael Andrews

      I need to average the sum of individusal sets of records. The example would be we have a page showing exam totals. I.e. exam1's max score, min score, average score, etc. It's broken up by exam. Now, there are multiple people who can take exam 1, so each exam taken record would have Multiple ItemTimeSpent Records. It's basically a record for the amount of time spent per question, per exam taken, per unique exam

       

      However, each exam will have multiple ItemTimeSpent records. Basically, I need to sum them per exam, and then

      average that sum.

       

      So, if exam1 had time spent of

      Exam1 - Record 1

      10

      20

      10

      15

      25

      20

      Total 100

       

      Exam1 - Record 2

      10

      10

      10

      15

      15

      10

      Total 70

       

      Our output would only have one column for exam1, with the previous stats I mentioned, but I'd also like to add in and average time spent columnn, that would basically sum ItemTimeSpent, then average each sum, per exam taken, in this case it would average 100 and 70, giving me 85 as one row under exam1

       

      I'm not quite clear how I get it to sum all the items, grouped by each exam taken, and then average that. I've tried this but it's not working

      AVG(Sum(ItemTimeSpent) / 60)