Need to exclude/supress records in CR 2008 1

[rbcasper]

I need to capture patients who have 2 or more coverages and have at least one Managed Care coverage. I grouped by patient and added a summary of patID. In Select Expert-Group Selection, I entered Count({PATIENT.PAT_ID}, {PATIENT.PAT_NAME}) >= 2. I now have a list of patients who have 2 or more coverages.

There are two types of coverages, Indemnity and Managed Care. How do I exclude or suppress members who have Indemnity coverage only. On the example below, I would want to exclude or suppress member3. Does anyone know how to do this. Any direction would be greatly appreciated. Thank you.

example:
member1 Indemnity
member1 Managed Care

member2 Managed Care
member2 Managed Care
member2 Indemnity

member3 Indemnity
member3 Indemnity

 

[lbass]

Create a formula like this:

//{@Indemnity}:
if {table.coverage} = "Indemnity" then 1

Then change your group selection formula to:

Count({PATIENT.PAT_ID}, {PATIENT.PAT_NAME}) >= 2 and
(
distinctcount({table.coverage},{patient.pat_name})>1 or
sum({@Indemnity},{Patient.Pat_Name})=0
)

-LB

 

[rbcasper]

Thank you so very much for your quick and great response! I tried the formula you suggested and it worked. Thanks again.
rb