Filter not working for me

[Karl_Spratt]

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. 

[PhilipMannering · Accepted solution]

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 solution]

@Karl_Spratt,

Please see below:

Attached the workflow,

Regards

[PhilipMannering · Accepted solution]

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.

[Karl_Spratt]

Thank you all, the solutions worked.

Really appreciate all the help here.

Regards,

Karl.