3 Replies Latest reply on May 15, 2009 1:58 PM by comment_1

    Average Calculation question

    Sendnot

      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!