How do I write the below filter :
I want to filter out the below but it is not working ---do I need to add something?
([CountDistinct_System_J1]=1 and Contains([Dup_System_J1],"**bleep**"))
OR ([CountDistinct_System_J2]=1 AND Contains("**bleep**",[Dup_System_J2]))
OR ([CountDistinct_System_J3]=1 AND Contains("**bleep**",[Dup_System_J3]))
thanks
Solved! Go to Solution.
Hey @Hi2023 it looks like your contains expressions are out of order here:
([CountDistinct_System_J1]=1 and Contains([Dup_System_J1],"**bleep**"))
OR ([CountDistinct_System_J2]=1 AND Contains("**bleep**",[Dup_System_J2]))
OR ([CountDistinct_System_J3]=1 AND Contains("**bleep**",[Dup_System_J3]))
The Syntax is Contains([Field],<Target>) so should be
([CountDistinct_System_J1]=1 and Contains([Dup_System_J1],"**bleep**"))
OR ([CountDistinct_System_J2]=1 AND Contains([Dup_System_J2],"**bleep**"))
OR ([CountDistinct_System_J3]=1 AND Contains([Dup_System_J3],"**bleep**"))
Hi @Hi2023
The contain expression (Contains(String, Target)) is defined below:
The string value is the column name
Target is what values you are looking for.
So I dont have to add anything else besides what you have above?
Looks fine other than that @Hi2023 - in filters, the statement is automatically evaluated as a boolean so no need to add an if statement around it or anything. Should be good to go!