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

Help with a formula to capture # of career site postings

Question
30
Views
0
Comments

Summary

Help with a formula to capture # of career site postings

Content

Hello - I'm trying to create a few formulas to determine the following - 

How many requisitions have been posted to our Internal Careers Site only and External Careers Site only even if they were posted historically and not actively posted today.

Here is 1 formula that I'm working with - 

count(case when "Requisition Posting"."Is Posted Internally" ='Yes' and "Requisition Posting"."Is Posted Externally"='No' then "Requisition Identification"."Req. Identifier" end)

Then I would also like to count how many requisitions were posted to both Careers Sites.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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