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

Calculating Percentage in OBIEE Report

16
Views
1
Comments
edited Oct 27, 2020 7:16PM in General Transactional Reporting (OTBI) 1 comment

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"

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!