Calculating Percentage in OBIEE Report

MarkS

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)

Syed Misbauddin-Support-Oracle

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 

 

User_7JCMG

How would I go about calculating the percentage of sales of a current day of the current week divided by sales of a day for the prior week in the edit column formula screen?