OTBI Ethnicity Reporting
Summary: Event headcount is incorrect. Showing 2 when employee has more than one ethnicity selected.
I'd love a second set of eyes on this. On recommendation from Raghu, I used his expression to show 'Two or More Races' for someone who has more than one race selected. In my table this works great. I'm noticing though that the event headcount still shows as 2 and so my pie chart is also off. I have 2 rows in my results. I should see a 50/50 split but because of the count of 2, it's showing as 33.33 and 66.67. I'm sure I'm missing something simple here. Appreciate any feedback.