Get Started with Redwood for Oracle Cloud HCM Begin Now
Ignore rejected candidates
Summary
want to ignore rejected candidates in most advanced candidate formulaContent
how can I edit this formula to ignored candidates that have been rejected.
MAX(CASE WHEN Rank(CAST(Replace(concat(CAST("Submission CSW Status - Historical"."Historical Step Sequence" AS CHAR(5)),CAST("Submission CSW Status - Historical"."Historical Status Sequence" AS CHAR(5))),' ','') AS Integer) BY "Requisition Identification"."Req. Identifier")=1 THEN "Candidate Identification"."Name" ELSE '' END BY "Requisition Identification"."Req. Identifier")
0