1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Using Discoverer to report on people not enrolled in a medical plan

Discussion in 'Oracle Discoverer' started by Mac, Jan 30, 2009.

  1. Mac

    Mac Guest

    I am trying to validate a report to our total active population. I am able to pull the folks in the medical plan, but don't know how to ask Discoverer to count employees not enrolled in the plan. It's like asking Discoverer to report on a blank value. Any ideas?
  2. Sadik

    Sadik Community Moderator Forum Guru

    Likes Received:
    Trophy Points:
    hi MAC, can you not use two calculations, one showing employees enrolled in medical plan and another showing employees not enrolled. That way the total of both columns would match your total employees list.

    that raises the question as to how are you capturing employees enrolled and not enrolled? through blanks or null?