Calculating Percentage in OBIEE Report
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"