Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Help with a formula to capture # of career site postings — Cloud Customer Connect
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

19
Views
1
Comments
edited Aug 10, 2016 4:33PM in General Transactional Reporting (OTBI) 1 comment

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!