How do I add a Self-minus-Rater (gap or difference) column to a 360 report?

In a 360 or cohort report you can display the difference, or gap, between two roles. A common example is Self minus the average of the rater or nominee roles, which shows how a person's self-rating compares with how others rated them.

Configure the difference in the Merge Manager

1. Select the score or rating text you want to display.
2. From Options, select Differences.
3. From Differences, select Difference Between Roles.
4. From Options, select the Base Role.

The result is positive when the displayed role's score is higher than the Base Role's score, and negative when it is lower. To show Self minus Nominees, set the displayed role to Self and the Base Role to Nominees.

Merge string

The role-difference metric is DiffReportId (use DiffReportIdPC for the difference as a percentage). The displayed role is supplied through Identifier and the base role through BaseIdentifier. Both take the numeric role ID from your cohort role setup, not the role name. For example:

{RatingScore.Score[SectionNo=n SubSectionNo=n Metric=DiffReportId Identifier=<SelfRoleId> BaseIdentifier=<NomineesRoleId> Decimals=1]}

Place this in the appropriate cell of your report table to create a difference column. The most reliable way to build it is to insert the merge string through the Merge Manager using the steps above, so the correct role IDs are filled in for you.

For full details, see Setting Up 360 Assessments and Displaying Scores in a Report.