Filter not producing True Results from data

[nshields001]

I'm currently working a workflow where I am filtering on an account, and then creating another filter on a product for a true/false result. When I run the workflow, the product filter produces zero True results although there should be data produced from the filter after looking through the inputted files.

Thank you

[Thableaus · Accepted solution]

Hi @nshields001 

THe problem here is that you're using the "AND" clause.

In this case you should either use "OR" or the operator "IN" as you did in your Account Filter.

Cheers,

[LukeG]

Hi @nshields001 

It looks like in your filters there is an "AND" operator. The reason nothing results as true is because no values in the product field are all of those values at once. 

In other words the product field cannot be "LFI148" AND "LF145", but it can be  "LFI148" OR "LF145"

Let me know if that helps or if there are any other questions.

Luke

[nshields001]

This worked thank you!