In the performance document review, if Manager reflection is not there, choose Employee reflection.

Summary

In the performance document review, if Manager reflection is not there, choose Employee reflection.

Content

Hello,

In the performance document review, check Manager's and Employee Rating/Reflection, pull employee rating only if manager's rating is null. if manager's rating is not null, pull manager's rating by ingoring employee's rating. can someone please suggest how to include this condition in OTBI filter.

attached the snippet of sample output where Rating Level Name column holds the rating of both Manager's and Employee's in two different rows. Participant name holds whose rating it is (Manager's or Employee's).