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

just need a count of completed submissions/profiles

Accepted answer
34
Views
2
Comments
edited Apr 12, 2017 4:27PM in Reporting and Analytics Taleo Enterprise 2 comments

Summary

just need a count of completed submissions/profiles

Content

hi, I have the formula below but it is adding candidates whose profile/submission is incomplete.  There should be 1 candidate on the req. who completed his profile but I am showing 2.  What am I doing wrong?  Thanks so much.

FILTER("Candidate Counts"."# Submissions Complete" USING "Submission CSW Status - Historical"."Historical Step Name" = 'Interviewing' AND "Candidate Regulations"."Ethnicity" = 'Ethnicity - Hispanic Latino')
 +
FILTER("Candidate Counts"."# Submissions Complete" USING "Submission CSW Status - Historical"."Historical Step Name" = 'Interviewing' AND ("Candidate Regulations"."Race" = 'Race - Black'))
 +
FILTER("Candidate Counts"."# Submissions Complete" USING "Submission CSW Status - Historical"."Historical Step Name" = 'Interviewing' AND ("Candidate Regulations"."Race" = 'Race - Asian' OR   "Candidate Regulations"."Race" = 'Race - Pacific Native'))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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