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

Fast Formula to consolidate participants' score with the manager overall score for the employee

edited Feb 4, 2025 12:59PM in Performance Management 1 comment

Summary:

I am writing a fast formula to calculate the Overall Summary Score on a performance document pulling from:

  1. Technical Goals Section
  2. Competency Section
  3. From Participants' Feedback on Core Competencies (Peers, Subordinates, Manager & Self)

I was able to generate the scores in the individual sections, However I am unable to pull the scores from the other participants (peers, Subordinates, Manager & Self) to include in the Overall Summary Score.

Note that the Manager score and Employee Score can be easily obtained in the performance document section but using the participant areas I can't get those scores.

The Overall Score =Manager's Technical Goal Score + Average of (Average[Peer Competency Scores, Subordinate Competency Scores], Manager Competency Score, Employee Competency)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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