AND Custom filter

[mihir_mir_jb]

Hi All,

I am trying to use custom filter by using "AND" as in the below expression.

[Hierarchy Level 12] in ("Asia", "EMEA", "US")

AND

[Hierarchy Level11] in ("GLOBAL")

However when I run the workflow I do not get any data in the T of the Filter tool.

Can you please guide what can be wrong here.

[atcodedog05]

Hi @mihir_mir_jb 

Basically using AND means your both condition should be TRUE. Hence you might want to check your data.

[messi007]

Dear @mihir_mir_jb ,

Could you share a sample dataset in order to help.

meanwhile, have tried to use two filters one with the first condition and the second with the second condition 

1- [Hierarchy Level 12] in ("Asia", "EMEA", "US") 

Then the true will be linked the new filter with the filter [Hierarchy Level11] in ("GLOBAL")

With this you will know where you don't match the condition.

Because i think the problem is on the data.

Hope that helps!

Regards,

[atcodedog05]

Hi @mihir_mir_jb 

Here is a workflow for the task. Good way is to split and check them

Workflow:

As you can see In is caseinsentive US is same as Us

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[MarqueeCrew]

@mihir_mir_jb ,

 likely it is case Sensitivity. 

uppercase([field]) in ("THIS", "THAT", "OTHER")

 cheers,

 mark