'Ethnicity - All' Headcount for US legislation to include 'Two or more Races' — 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

'Ethnicity - All' Headcount for US legislation to include 'Two or more Races'

Summary:

Based on the current functionality the only way to report on employee headcount by ethnicity is to use 'Ethnicity' which selects a primary ethnicity for each employee (Cannot use in the US because employee's do not select a primary ethnicity) or to use 'Ethnicity - All' which will inflate headcount numbers by counting employees in each ethnicity they select. As a result, we are attempting to create a custom Ethnicity field to capture employees that select more than one ethnicity as 'Two or more Races'.

I'm using the HCM - Workforce Core SA and have tried a few variations of the formula below and the value shows correctly in a report with Person number but when I attempt to aggregate by other dimensions for Employee Headcount totals, like Business Unit, it does not aggregate correctly. Any suggestions for how to do this effectively in FDI?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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