You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Performance Management Fast Formula for Rating Range

Received Response
edited Sep 8, 2021 2:50PM in Performance Management 2 comments


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. 

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!