OTBI Report for Ethnicity
Summary
OTBI Report for EthnicityContent
Hello,
CASE WHEN COUNT("Worker"."Employee Ethnicity Code" BY "Worker"."Person Number")>1 THEN 'Two or More Races' WHEN "Worker"."Employee Ethnicity Code" = '4' THEN 'Hispanic or Latino' ELSE "Worker"."Employee Ethnicity" END
We are looking to use a case statement for our OTBI reports that include Ethnicity. This case statement reflects Two of More Races correctly when someone has selected more than one ethnicity, but we need it to show "Hispanic or Latino" regardless if they select that ethnicity and something else. Based on the EEO criteria Hispanic and Latino is the defined value regardless if they selected more than one value.