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: AI Resources for Oracle Cloud HCM – Go Here

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

what's wrong with this formula?

edited Dec 13, 2022 7:02AM in Taleo Enterprise 1 comment

Content

Trying to get the percentage of applicants who haven't been moved in more than 14 days, individually the counts work fine, but when I try to divide it gives me zero's.

 

COUNT(DISTINCT CASE WHEN (TIMESTAMPDIFF(SQL_TSI_DAY,"Submission CSW Status - Current"."Current Status Start Date", CURRENT_TIMESTAMP)) > 14 THEN "Submission General Info"."Submission Identifier" END)/COUNT(DISTINCT "Submission General Info"."Submission Identifier")

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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