formulae help

[ManuelRodrigues]

Hi Team,

I am having some issues with the custom filter. I am basically trying to pass any field that contains a Null or Check or No Capex to the false Anchor. Am i doing something wrong with this formula:

[Cost Center - Cost center ID] != "Check" and [Cost Center - Cost center ID] = "Null" and [Cost Center - Cost center ID] != "NO CAPEX"

Cost Center - Cost center ID
NULL
11100ADT
11100ADT
11100LL
1116843
1117029
1119496
1120082
1330030
1330194
1330246
1330261
1330261
1330262
1880585
NO CAPEX
NO CAPEX

[JosephSerpis · Accepted solution]

Hi @ManuelRodrigues a IN function is better when you have a list of things within one column or in your case a NOT IN. Also it better to actually use multiple filters then try to combine a complex argument in a filter as they are more efficient and easier to troubleshoot.

[AngelosPachis]

Hi @ManuelRodrigues ,

You are missing an exclamation mark in your second statement, 

[Cost Center - Cost center ID] != "Check" and [Cost Center - Cost center ID] != "Null" and [Cost Center - Cost center ID] != "NO CAPEX"