Performance Management Fast Formula for Rating Range

Content

The performance document is divided in the following sections:

Sections	Section Weight	Section Type
Goals	50	Performance Goals
Competencies	17	Profile Content
Leadership Personality Trait	16	Profile Content
Leadership Values	17	Profile Content

We have created different item catalog for Competencies, Leadership Personality Trait and Leadership Values under the same template of Competency. Further we have the following requirement:

• There is a range of rating.
• If the rating falls in the range, it should show the corresponding value

We tried using a Performance Rating Calculation fast formula (Formula attached) to achieve this requirement but it did not help. The calculated rating is either same or zero for all the three sections i.e. Competencies, Leadership Personality Trait & leadership Values.