DFF Help Needed: Need Ethnicity Indicator DFF if the employee selects more than one ethnicity
With 20B, and how Two or More Races is no longer applicable, and employees can now select multiple races, we have an issue with a whole bunch of broken statistical reports.
THUS I need help with what options we could build
Option 1 - Can I build a DFF indicator that uses SQL logic? For example: ... If two or more ethnicities are selected in the per_ethnicity table are selected, default to YES...then store the Yes under a DFF called "Two or More Races" indicator.
Option 2 - Can I keep the Two or More Races from the per_ethnicity table (it still appears as enabled on the table) and if someone selects multiple races, then could I default the reportable values as the Two or More Races field, instead of being reported in the actual race/ethnicity they checked.