Hi folks,
I have three variables :-
@ScoreA DECIMAL(10,7)
@ScoreB DECIMAL(10,7)
@ScoreC DECIMAL(10,7)
@FinalScore DECIMAL(10, 7)
I wish to get the average of the three scores. BUT 1, 2 or all 3 values might be zero.
Eg. scenarios:
- A = 1.4, B=3.5, C=5.0; FinalScore = 3.3
- A = 0.0, B=0.0, C=0.0; FinalScore = 0.0
- A = 1.1, B=0.0, C=0.0; FinalScore = 1.1
- A = 0.0, B=2.0, C=4.8; FinalScore = 3.4
Cheers!