Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Dont' filter out Null in selection criteria

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?

Former Member
Former Member replied

go to file

report options

check null values boxes

formula

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question