Incorporate AND in Set Analysis after ORs

[JustinDallas]

Hello Folks,

I've currently got this set analysis which reads:

A or B or C or D

What I would like to say is something like this

( A or B or C or D) AND ( Y = Foo ).

How do I express the phrase AND ( Y = Foo )?

This is the monstrosity I've got, essentially once we've satisfied the date requirements, I need to add an "AND EmploymentType='Contractor'".  I could put this into each and everyone one of my date OR filters, but that seems sloppy and will make my statement even less readable.

COUNT( 
{<[Employee Start Date]={"<=$(=Min(GenDate))"}, mpp_terminationdt={">=$(=Min(GenDate)) <=$(=Max(GenDate))"}>+
        <[Employee Start Date]={">=$(=Min(GenDate))"},  mpp_terminationdt={"<=$(=Max(GenDate))"}>+
            <[Employee Start Date]={">=$(=Min(GenDate)) <=$(=Max(GenDate))"}, mpp_terminationdt={">=$(=Max(GenDate))"}>+
                <[Employee Start Date]={"<=$(=Min(GenDate))"}, mpp_terminationdt={">=$(=Max(GenDate))"}>} 
                  mpp_id
)  

Any help is greatly appreciated.

[agigliotti · Accepted solution]

you could add an If statement as below:

Count( {< set analysis >} if( EmploymentType = 'Contractor', mpp_id ) )

OR

try adding in Set Analysis as below:

Count( { < set analysis > * < EmploymentType = {'Contractor'} >} mpp_id )

[JustinDallas]

Well, that was anti-climatic...