2 Replies Latest reply: Dec 12, 2017 10:32 AM by Justin Dallas

# Incorporate AND in Set Analysis after ORs

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.

• ###### Re: Incorporate AND in Set Analysis after ORs

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 )

• ###### Re: Incorporate AND in Set Analysis after ORs

Well, that was anti-climatic...