Oracle Transactional Business Intelligence

Products Banner

Calculating Percentage in OBIEE Report

207
Views
1
Comments

Summary

Calculating the Percentage of two columns. One column being a calculated field in itself and the other pre-defined field.

Content

Hello,

I am trying to calculate the percentage of two columns. Percentage of # of Candidates Active in Background Check + Active in Road Test / # of Openings Left to Fill. The one column is a pre-defined field and the other is a calculated field. Below is what I have so far, but it's not calculating correctly when added to a pivot table in OBI. Any help would be greatly appreciated.

(FILTER("Candidate Counts"."# Candidates" USING (("Application Current CSW"."Application Current CSW Step" IN ('Background Check DHC')) AND ("Application Current CSW"."Application Current CSW Status" IN ('Initiate Background Checks','Background Checks Successful / N/A for Internals','Waiting for Results')))) + FILTER("Candidate Counts"."# Candidates" USING (("Application Current CSW"."Application Current CSW Step" IN ('Road Test / Meet & Greet DHC')) AND ("Application Current CSW"."Application Current CSW Status" IN ('Waiting for Results','Road Test Complete - Pass'))))) /"Requisition Identification"."Req. No. Openings Left To Fill"

Thanks,

Mark

Version

11g Release 1 (11.1.1)

Comments

  • Not sure if below would work but just try to add () for second in division like (Column1)/(Column 2)

    (FILTER("Candidate Counts"."# Candidates" USING (("Application Current CSW"."Application Current CSW Step" IN ('Background Check DHC')) AND ("Application Current CSW"."Application Current CSW Status" IN ('Initiate Background Checks','Background Checks Successful / N/A for Internals','Waiting for Results')))) + FILTER("Candidate Counts"."# Candidates" USING (("Application Current CSW"."Application Current CSW Step" IN ('Road Test / Meet & Greet DHC')) AND ("Application Current CSW"."Application Current CSW Status" IN ('Waiting for Results','Road Test Complete - Pass'))))) / ("Requisition Identification"."Req. No. Openings Left To Fill")

     

    Also please try to see if aggregation rule is right 

     

    rule.png