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
Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

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!