Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Ethnicity vs Race — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Ethnicity vs Race

Question
53
Views
0
Comments

Content

Hello I am new to this system and I am looking to create a variable that says if the candidate selected Not Hispanic or Latino, then count race they selected. If the candidate selects Hispanic or Latino, then do not count any other race selections. So far I have the below and Its not working.

Dimension:

=If([Candidate Ethnicity (EEO2)]="Hispanic or Latino";"Hispanic or Latino";[Candidate Race (EEO2)])

Measures continue in the below format for each race

=Count([Candidate ID])Where([Candidate Ethnicity (EEO2)]="Black or African American")

I am missing somehthing big, what is it?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!