multiple filters in filter for not null

[rrafferty2]

Hi All:

I want to add a second filter condition to my filter.

Why  am I getting an error when I add AND

I want second field to not be empty or null

[Subconsol Name] IN ("1.0 A ","10.0 B","11.0 C Only")

AND !isnull ([Tier Association])

[fmvizcaino · Accepted solution]

Hi @rrafferty2 ,

I reproduced your filter with some testing data and looks like it is working as it supposed to work. 

The only detail is related to your first condition, it appears to have an additional space in "1.0 A".

Example attached.

Best,

Fernando Vizcaino

[AbhilashR · Accepted solution]

Hi! What is the error you are getting? Would you also be able to give us a sample row of data to re-create your error to troubleshoot?