AnsweredAssumed Answered

Average Calculation question

Question asked by Sendnot on May 15, 2009
Latest reply on May 15, 2009 by comment_1

Title

Average Calculation question

Post

I have a database for calculating grades by quarter. I would like to have a calculation field average the quarters and a final exam score, but the icing on the cake would be if I could it average only if the fields contained a numeric value. For instance, if a teacher entered a numeric value for Quarter 1, Quarter 3 and Quarter 4 but left Quarter 2 blank, the average wouldn't be affected by the blank value for Quarter 2.

 

This is probably really simple, but I need a nudge in the right direction- Thanks! 

Outcomes