Competency Section Calculation In Performance Document

Summary

need a fast formula which calculates the average of competencies in the performance document and the avergae is then compared to 4 defined range to give a final rating for competency section

Content

We have 4 ratings A, B, C, D for which the corresponding numeric ratings are 101,106,111,116. 

And 4 defined ranges:

A: = 101

B: >101 to 106 (inclusive of 106)

C: >106 to 111 (inclusive of 111)

>111 to 116 (inclusive of 116)

 

So if the average of 7 competencies  is 108 then the rating to display should be C . which if we use average as per standard functionality would give B . Using the below mentioned formula which gives an error

 

L_RETURN_VALUE = 0