Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a way for me to take the set analysis function
Count({<IND={A}>} Ethnic)
and use it to get the percentage of ethnicity based on the total of all ethnicity?
Example
Asian 432 43.7%
Black 196 19.8%
Hispanic 360 36.4%
TOTAL 988 100.0%
I want to find out what is the percentage of Asian, Black, Hispanic, etc based on the total.
Thanks
Mauricio
Count (Ethnic) / Count(TOTAL Ethnic)
Count (Ethnic) / Count(TOTAL Ethnic)
Thanks KSCHIECK. That steered me in the right direction. Since I was using the set analysis to differentiate between my active and inactive populations, I wanted to get percent totals for each one.
Count ({<[IND]={A}>} [Ethnic])/Count(TOTAL{<[IND]={A}>} [Ethnic])
Thanks again!
Mauricio