Filter Out ( Not Equals) different values using the OR operand

[Karl_Spratt]

Hi Community,

I'm trying to Filter Out ( Not Equals) different values using the OR operand, but it's not working, If I use one value say [L_ORDER_STATUS] != "Offer Expired" the filter works, but if I add additional criteria using the OR if doesn't work  for me.

Can someone explain to me the issue / fix.

i want to bring back all the L_ORDER_STATUS except these values.

Filter out Multiple Values using OR 

[L_ORDER_STATUS] != "Offer Expired"
OR
[L_ORDER_STATUS] != "Draft"
OR
[L_ORDER_STATUS] != "Entered"

TIA,

Karl. 

[binuacs]

@Karl_Spratt Use the AND operator instead of OR

[L_ORDER_STATUS] != "Offer Expired"
AND
[L_ORDER_STATUS] != "Draft"
AND
[L_ORDER_STATUS] != "Entered"

[Christina_H · Accepted solution]

You need to switch your ORs to ANDs.  If the value is "Draft, it meets the criteria !="Entered".  With OR, as long as it meets one of the criteria the result will be TRUE, so it passes through.

NOT(A OR B OR C) is the same as NOT A AND NOT B AND NOT C

Alternatively, you could use NOT IN("Offer Expired","Draft","Entered")

[Karl_Spratt]

Thanks all that worked.

Cheers Karl.