Ethnicity causing Workforce Trend SA to produce inaccurate headcount
When adding ethnicity to the Workforce Trend SA it causes the Period Start and End headcount to double/triple for those that have selected two or more races.
I have attached a sample report with the custom field I'm using to group the team member's ethnicity. But I'm having difficulty with getting the headcounts to work as expected. Has anyone else had this issue and what was your work around? I need to use the period active start and end dates fields for this report as I'm working out the average actives for a 12 month period.
When adding the Ethnicity Field: