Deriving column value based in ROLE. — Cloud Customer Connect
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

Deriving column value based in ROLE.

edited Jun 23, 2020 6:25PM in Reporting and Analytics for HCM 1 comment

Summary

Deriving column value based in ROLE.

Content

Hi All,

Need HELP

I'm creating report in OTBI and in report there is field call"Is Manager" and logic for this field will be if person has Role = '**** Line manager' then write Y Else 'N'.

In Column formula I wrote CASE WHEN but problem is if employee has Role '**** Line Manager' & '**** Employee Role' then it writes 2 rows in a report.

Whereas I want only one row with Value 'Y'.

Can someone help please.

Version

20c
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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