Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need to exclude/supress records in CR 2008 1

Status
Not open for further replies.

rbcasper

Technical User
Jul 21, 2013
5
US
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
 
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
 
Thank you so very much for your quick and great response! I tried the formula you suggested and it worked. Thanks again.
rb
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top