ST ID
SUB ID
Quiz 1
Quiz 2
Quiz 3
Quiz 4
Quiz 5
Quiz Total (Best 3 )
0111
Maths
9
9
9
10
10
0111
Eng. I
9
7
7
8
9
0111
Eng II
10
8.5
7
8
8.5
0111
Eng. Lit.
9.5
9.5
8
8.5
8
How can I calculate the Quiz Total field that is the addition of the best three quizzes.