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

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.

filter out.PNG

Workflow

Accepted answers

Christina_H

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")

All comments

binu_acs

@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

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703