Performance Management Fast Formula for Rating Range
The performance document is divided in the following sections:
|Sections||Section Weight||Section Type|
|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.