2 Replies Latest reply on Jan 5, 2017 1:39 PM by Grégoire Michel

    Advanced Logic Question

    Eric Rosenberg

      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