Dont' filter out Null in selection criteria
I try to filter a field by using selection formula. The field contains value: 'Y', 'N' and null. When I set the field1<> Y or not start with Y, it will filter off those record with null value. How to filter off 'Y' and keep the null value data?
go to file
check null values boxes
if isnull(field) or if <> 'Y' then true