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
Get Started with Redwood for Oracle Cloud HCM   Begin Now

Formula for # of candidates in Inteview step

Accepted answer
70
Views
1
Comments
edited Dec 13, 2022 7:06AM in Taleo Enterprise 1 comment

Summary

We currently have a formula to count the number of candidates in the interview step (not including those rejected) but we have added a new status and need to update the formula

Content

Our current formula for the "# of Candidates in Interviews" is EVALUATE_AGGR('COUNT(DISTINCT CASE WHEN %1 In (''Interviews'') AND %2 In(''Schedule face to face Interview'',''Face to Face Interview Scheduled'',''Under consideration after interview'',''Schedule follow-up Interview'',''Follow-up Interview Scheduled'',''Progress to Offer Stage'')  THEN %3 END)' AS NUMERIC,"Submission CSW Status - Current"."Current Step Name","Submission CSW Status - Current"."Current Status Name","Submission Identifier")

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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