'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?