Weighted values
(from GMCB Reader Review Form)
Average when values may be missing
To account for ‘no basis for evaluation’ type of responses (from GSBS - CTS Interview Evaluation)
Note that the data type on the fields still needs to be Integer or Real, even if some on the values are not numeric:
(@CTS_IntEval1+@CTS_IntEval2+@CTS_IntEval3+@CTS_IntEval4+@CTS_IntEval5+@CTS_IntEval6)/(((@CTS_IntEval1)?1:0)+((@CTS_IntEval2)?1:0)+((@CTS_IntEval3)?1:0)+((@CTS_IntEval4)?1:0)+((@CTS_IntEval5)?1:0)+((@CTS_IntEval6)?1:0))
Add Comment