Diverse Slate Reporting Update
SummaryDiverse Slate Reporting Update
I am trying to update a formula in OBI to reflect changes to our diverse slate strategy and running into difficulty.
Below is the current formula:
This formula populates a "Y" if there is at least one female and one ethnicity diverse candidate at the interview stages and beyond. If there is one female that is ethnically diverse that satisfies the requirement.
CASE max(CASE WHEN "Submission CSW Status - Current"."Current Step Name" IN ('1st Round Interview(s)', '2nd Round Interview(s)', 'Additional Interview Round(s)', 'Hire', 'Offer', 'On-Campus Interview', 'On-Site Interview(s)','Verification','