Custom Filter

[CherylH]

Hi,

Can someone identify the Parse Error Malformed Function call in this customer filter?  All letters are colored in Alteryx so it pretends like it is a good formula.

isnull([BB File} or Contains ([Amazon Siebel Brand],"Does not Qualify")

[echuong1]

Try this:

isnull([BB File]) or Contains ([Amazon Siebel Brand],"Does not Qualify")

[messi007]

below the correct one 

isnull([BB File]) or Contains ([Amazon Siebel Brand],"Does not Qualify")

you used "}" instead of "]" and you forgot the parenthesis after the null

Hope that helps !

Regards,

[CherylH]

Say how I say "Does Not Contains" instead of contains?

isnull([BB File]) or Contains ([Amazon Siebel Brand],"Does not Qualify")

[messi007 · Accepted solution]

Try this

isnull([BB File]) or not Contains ([Amazon Siebel Brand],"Does not Qualify")

You can use 

isnull([BB File]) or ! Contains ([Amazon Siebel Brand],"Does not Qualify")

Hope that helps!

If it solve the problem please mark it as solved 🙂

Regards,

[CherylH · Accepted solution]

Atom,

Not sure what you mean. 

Tried this: isnull([BB File]) or not Contains ([Amazon Siebel Brand],"Does not Qualify")  Letters are all colored but the result is not correct.   

If I type in Does Not Contains-letters turn black.

It's so close...

[messi007 · Accepted solution]

It's working well for me,

Please see the attached workflow.

If this post helps, then please consider Accept it as the solution 🙂

Regards,