Average Calculation question
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!