AnsweredAssumed Answered

Advanced Logic Question

Question asked by 0b27d7be79ca98ec050c7b6d385fa61443842dd1 on Jan 5, 2017
Latest reply on Jan 5, 2017 by e6615dd679b5dd0c3e60c20085706f392a9af2cb

Good Day All - I am curious as to see if anyone can add any clarity to this question.  I have created an advanced filter that says 1 and (2 or 3).  The logic in the smart list is:

1.  Filled out form - xxxx

2.  Email address NOT contains - xxxx

3. Company name NOT contains - xxx

When I run this smart list the results returns leads that have both the NOT email address and the NOT Company Name for the same record.  I guess I could see if they had one or the other but not both.  When I reorder the logic to be (1 or 2) and 3 it works just fine.  

 

When I reorder the logic to be (1 or 2) and 3 it works just fine.  

1.  Email address NOT contains - xxxx

2. Company name NOT contains - xxxx

3. Filled out form - xxxx

 

So this has peaked my interest as to why the original logic does not work.  My thought is it has something to do with the NOTs.  Any insight into this would be much appreciated.  Thanks

Outcomes