Need to add the logic in OTBI Report

Question

Please apply logic to the "Ethnicity" field: If multiple selections include Hispanic, only populate Hispanic in the ethnicity field, if multiple selections do not include Hispanic, populate Two or More in the ethnicity field.

User_WF2X0 · Answer

CASE WHEN "Worker"."Employee Ethnicity" = 'I am Hispanic or Latino.' THEN 'Hispanic' ELSE 'Two or more races' END

used this condition still it was pulling duplicates

Sumanth V -Oracle · Answer

@User_WF2X0 - This community is specifically dedicated to FDI/FAW queries. For OTBI-related discussions, we have a dedicated community forum. Please use the following forum for OTBI-related queries in the future:
OTBI Community Forum

@John Hung-Oracle

Could you kindly assist in moving this thread to the OTBI community?

Thank you!

gclampitt · Answer

Have you tried anything ? Looked at the Case statement?

case when Ethnicity like '%Hispanic%' then 'Hispanic' else  Ethnicity end