OTBI Report - Filter Ethnicity

Summary:

Following EEO, we had attempted to filter ethnicity/race based on their category.

If Hispanic or Latino + Others selected, they would categorized as Hispanic or Latino.

If Non-Hispanic or Latino + Non-Hispanic or Latino selected, they would categorize as Two or More Races.

Content (required):

I am looking to add a formula in Ethnicity that can provide these result in an OTBI report.

I had came across this but it is giving me Two or More race even if they are Hispanic/Latino.

CASE WHEN SUM(FILTER("Workforce Management - Worker Assignment Real Time"."Worker Assignment"."Assignment Count" USING ("Workforce Management - Worker Assignment Real Time"."Worker"."Employee Ethnicity Code" = '4')) BY "Workforce Management - Worker Assignment Real Time"."Worker"."Assignment Number") >= 1 THEN 'Hispanic or Latino' WHEN COUNT(DISTINCT "Workforce Management - Worker Assignment Real Time"."Worker"."Employee Ethnicity Code" BY "Workforce Management - Worker Assignment Real Time"."Worker"."Assignment Number") = 1 THEN "Workforce Management - Worker Assignment Real Time"."Worker"."Employee Ethnicity" WHEN COUNT(DISTINCT "Workforce Management - Worker Assignment Real Time"."Worker"."Employee Ethnicity Code" BY "Worker"."Assignment Number") >= 2 THEN 'Two or More Races' ELSE NULL END