"And" / "Or" discrepancy in list building with exclusionsSOLVE
Oct 19, 2020 1:16 PM
I am building a list with 2 basic criteria (is not one property, another property is known) followed by 3 list exclusions. Originally i had it set up with a single "block" of criteria, with the 2 basic ones I mentioned and a single string of "and" criteria for the lists ("is not a member of x AND is not a member of y AND is not a member of z").
If I was building this based on INclusion of lists I know I'd need to use the OR function and separate out the lists because i'm not asking that the contact be in all 3 lists simultaneously, I just want anyone from any of the 3 lists. But being an exlusion i thought the AND function would work. Technically it is asking that the contact not be in all 3 of them, but I thought that should not matter, since being in any one would "kick out" anyway, which is what I want.
Yet as a failsafe I decided to reset it with OR functions, cloning the block and making one for each of the 3 lists i wanted to exclude, and in doing so the list added a significant number of contacts. I thought it would be exactly the same if I'd done it right.
I think I am going to use my original list as described above since it's smaller and would seem more precise for that reason alone, but I'd love to konw what is going on here, can anyone help unwind this?
Solved! Go to Solution.
Oct 19, 2020 4:18 PM - edited Oct 19, 2020 4:21 PM
Thanks @Ad3pinto, I've noticed an error in reasoning in my earlier post which I've now corrected.
A contact will be let into your OR list if he or she is not in list 1 OR not in list 2 OR not in list 3. If the contact is in list 1 but not in list 2 or 3, then he or she will get into the list. Because he or she's not in list 2 or 3.
Effectively, the OR list is only suppressing the overlap of list 1+2+3.
If you want to work around this brain teaser, I'd suggest that you build an overall suppression list which contains contacts from list 1 or 2 or 3 and then you suppress this one master list.
Hope this helps!
Hat mein Beitrag deine Frage beantwortet? Bitte hilf der Community und markiere ihn als Lösung.