Filter not working for me

Question

Hi Community,

Need some help please.

I'm trying to filter out from my data a range of Statuses I've tried, the Does Not Equal filter and Does Not Contain   in my WF (see attached) but neither is removing all the data I want to exclude, can someone please explain what I'm doing wrong here?

Attaching a sample of the completed data

I want to exclude the [flow_status_code] with these values
"CLOSED"
"CANCELLED"
"OFFER_EXPIRED"
"ENTERED"
"DRAFT"

TIA,

Karl.

Not Equal.PNG

Does Not Contain.PNG

SO_Detail_Rpt.xlsx

philipmannering · Accepted Answer

I think you just want to replace your ORs with ANDs.

If you think about it, something like,

[dice_roll] != 5 OR
[dice_roll] != 6

will always be true, because when the roll is 5 you get False or True = True and when the roll is 6 you get True or False = True. Any other number is True or True = True.

Basically think about how these booleans get evaluated for you different data entries.

messi007 · Accepted Answer

@Karl_Spratt,

Please see below:

Attached the workflow,

Regards

philipmannering · Accepted Answer

A nice shortcut for these filters would look something like this,

[flow_status_code] not in('CLOSED', 'CANCELLED', 'OFFER_EXPIRED', 'ENTERED', 'DRAFT')

I find this easier to understand too.