Thank you Sachin and Rachel. Oracle Support resolved this by using this formula. FILTER("Candidate Counts"."# Submissions Complete" USING "Candidate Identification"."Record Status" = 'AVAILABLE') I used this formula below before and did not get the right answer but now, checking with this formula everything looks right.…

Thank you very much Rachel . I tried this before and something just wasn't right. I tried it now, I got all the reqs but # submissions still not accurate. I know there is something wrong but my brain is about to burst. For my first query I filtered by the following and used no of submissions completed: Record Status is…

Thank you Arun

Thank you very much for your response Arun. I checked the docs I suspected earlier I may need to write an SQL statement but it seems we are using a different subject area. This is for Taleo Recruiting OBIEE. If I have to write an SQL Statement I am not sure of what fields to pull the Active recruiter names from.Thanks…