Filter data in multiple conditions

[Yolande_Q]

Hi, 

I would like to filter out data in multiple conditions with below data set:

1. GAM name is blank 

2. Split_Remarks is "Roll up" and blank

3. Special target is NOT "TBS Asia" and "TBS EMEA"

ID	GAM Name	Split_Remarks	Special Target
123	Apple	Roll Up	TBS Asia
456			IRU
789	Amazon		CM
1011		Team support	TBS EMEA
1213		Team support	TBS EMEA
1415	Twitter	Team Owner	CM

Appreciate any feasible solutions. 

[JosephSerpis]

Hi @Yolande_Q I mocked up and approach which use multiple filters as this approach is generally faster in terms of compute rather than having one complex logic formula in a single filter plus is easier to troubleshoot.

[Raj]

Please find attached

IsEmpty([GAM Name]) or IsNull([GAM Name]) && (Trim([Split_Remarks]) = "Roll Up" OR IsEmpty([Split_Remarks])) && (Trim([Special Target]) != "TBS Asia" AND Trim([Special Target]) != "TBS EMEA")

this will help.

[grazitti_sapna]

Hi @Yolande_Q 
I have made Workflow for your Problem. Please Check.
If it works Kindly accept it as Solution.
Thanks