General OBIEE

Get Involved. Join the Conversation.

Topic

    Maria Lieberman
    Help with a formula to capture # of career site postings
    Topic posted August 10, 2016 by Maria LiebermanSilver Medal: 2,000+ Points, tagged Analyses, Customizing Reports, OBIEE Answers, Reports 
    36 Views, 1 Comment
    Title:
    Help with a formula to capture # of career site postings
    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

     

     

     

     

    Comment

     

    • 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