Oracle Transactional Business Intelligence

Products Banner

I'm currently working on a OTBI report with a requirement of Plan Participation Details.

Received Response

Question: I need the Purchase Plan Hours , Plan Current Balance Hours & Plan Used Hours. Upon building the report I encounter some issue if the employee have a multiple plan, It sum ups all the Purchase Plan Hours. is this possible to separate the hours?

Plan #1: 100 Purchased Plan Hours

Plan #2: 35 Purchased Plan Hours

In my report I pulled the sum of all the plans hours how can I separate them and pulled only the Plan #2. Should be 35 Hours Only. I already added a filter with Plan Name USA Purchased PTO.