AnsweredAssumed Answered

Finding average

Question asked by cn2 on Aug 18, 2014
Latest reply on Aug 18, 2014 by cn2


Finding average


     I have a student table related to a score table defined by a keyId field and subject field. In the score table each record is a score with type of test (example test or quiz).  I need an average that works by first averaging the (tests) and then (quizs) and then an average of the two. I can make it work like this (GetSummary ( SumAverageQuiz ; SumAverageQuiz ) + GetSummary ( SumAverageTest ; SumAverageTest )) / 2 , but this obviously doesn't work if one of these is blank. thanks for any help