Help with a formula to capture # of career site postings
SummaryHelp with a formula to capture # of career site postings
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.