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
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

Report column to show # submissions in a specific step/status

edited Dec 13, 2022 7:11AM in Taleo Enterprise 2 comments

Summary

please advise on correct formula syntax

Content

I need to pull the number of candidates currently in the "New" step and the "To Be Reviewed" status.  I am using the following formula and getting a blank in the table view and the number of completed submission in a tile (39).  The expected result in this case is 15 submissions. See attached image.

CASE WHEN "Submission CSW Status - Current"."Current Step Name" = 'New' AND "Submission CSW Status - Current"."Current Status Name" = 'To Be Reviewed' THEN "Candidate Counts"."# Submissions" END

What am I doing wrong?  Please advise. 

Thank you in advance!

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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