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

Formula help for # openings minus accepted offers

Received Response
42
Views
1
Comments
edited Dec 13, 2022 7:01AM in Taleo Enterprise 1 comment

Summary

Formula help for # openings minus accepted offers

Content

Hello - I'd like to create a formula to show # of remaining openings minus accepted offers.  I don't want to use the standard "Requisition Counts"."# Openings (Accepted)" or "Requisition Counts"."# Openings (Hired)" because it doesn't suit our needs.

Here is the formula that I have but I want to subtract out "Candidate Counts"."# Submissions Offer Accepted"

CASE WHEN Filter("Requisition Counts"."# Openings" USING "Requisition Primary Location"."Location Level1 Name" IN ('Americas')) IS NULL THEN 0 ELSE "Requisition Counts"."# Openings" END

Any ideas on how to accomplish this?

Many thanks in advance!

Regards,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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