It comes out all zeros. Here is what I have so far. I tried count. Any ideas?
case when `Ethnicity` = 'White' then 'White'/`Count`
when `Ethnicity` = 'Asian' then 'Asian'/`Count`
when `Ethnicity` = 'American Indian/Alaskan Native' then 'American Indian/Alaskan Native'/`Count`
when `Ethnicity` = 'Black or African American' then 'Black or African American'/`Count`
when `Ethnicity` = 'Hispanic or Latino' then 'Hispanic or Latino'/`Count`
when `Ethnicity` = 'Native Hawaiian or Other Pacific Islander' then 'Native Hawaiian or Other Pacific Islander'/`Count`
when `Ethnicity` = 'Not specified' then 'Not specified'/`Count`
when `Ethnicity` = 'Two or more races' then 'Two or more races'/`Count`
end