Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Report column to show # submissions in a specific step/status — 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

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

Received Response
14
Views
2
Comments
edited Jun 1, 2021 4:07PM in Reporting and Analytics 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!