Help with a formula to capture # of career site postings

Maria Lieberman

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.

So, ideally I would like 3 columns of data.  Any help would be greatly appreciated!

Thanks!

Regards,

Maria

 

 

 

 

Sachin Sirohi

Hi Maria,

I think Pivot report can work for you. You can use Req ID for count under these columns there.

Thanks,

Sachin