Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Turnover by Ethnicity - Report Assistance — 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

Turnover by Ethnicity - Report Assistance

Question
15
Views
0
Comments
in General Transactional Reporting (OTBI)

Summary:

We are currently running into issues creating a Turnover report by Ethnicity due to how ethnicity is handled in Oracle. This is causing employees to be duplicated if they have selected more than one race.

I've included the code snippet below which was suggested in the community (When person count is greater than 1 then 'Two or more races'), but the report is not providing the desired results. The report ends up duplicating the same values multiple times (see screenshot below). I've attempted to set up a pivot table so that it would only provide one value and remove all the duplicates, but had no luck. It seems as though you need to include the Person Number on the report in order for the formula to work and display them as 'two or more races',

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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