cancel
Showing results for 
Search instead for 
Did you mean: 

Dont' filter out Null in selection criteria

Former Member
0 Kudos

Greeting,

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?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

go to file

report options

check null values boxes

formula

if isnull(field) or if <> 'Y' then true

Former Member
0 Kudos

where do i put the formula in? i am really confuse

Former Member
0 Kudos

Try this record selection formula

isnull(field)=true

and at the top select "Default values for nulls" instead of "Exceptions for nulls" in record selection formula.

this gives you the records with null values.

Regards,

Raghavendra

Answers (0)