Set Analysis Exclude Part of Modifier Set

[mbeccaria]

I am trying to build a set that excludes results based on part of a modifier. Here is my expression:

Count(
{
     (
          <[Program Enrollments.End Date] = {'No Entry'}>
          *
          <[Program Enrollments.Program Name] = {Outpatient,CCBHC}>
          *
          <[Services.Is No Show]={'No'}>
     )
     -
     <[Services.Service Date]= {">=$(=Date(Today()-21,'YYYY-MM-DD'))"}>
}
     [Services.Service Date]
)

I WANT to return clients who are in "Outpatient or CCBHC" programs, are active (thus have no Program End Date), and who have had services where they showed up (Is No Show=No)
BUT if they received a service in the past 21 days, do NOT include them.

So I want ALL users who meet the first three conditions, but REMOVE the users from that set if they have a record that meets the last condition (had a service in the past 21 days).

Can't quite figure it out. Can you help?

[stevejoyce · Accepted solution]

Count(
{
     <
          [Program Enrollments.End Date] = {'No Entry'},
        
          [Program Enrollments.Program Name] = {'Outpatient','CCBHC'},
         
          [Services.Is No Show]={'No'}
     >
     -
     <[Services.Service Date]= {">=$(=Date(Today()-21,'YYYY-MM-DD'))"}>
}
     [Services.Service Date]
)