Filter on Not blank and Not value

I need to generate a report from Navision where the Vendor state is not equal to an option value and is mot blank ( Yeah I know that blank states shouldn't have happened but I have vendors with no state and I need to exclude them)

"<>''&<>cellref doesn't work neither does <>@@blankcell & <> cellref

I suspect it 's simple but how do you filter on two or more <> on the same field when one is a blank or null

1 comment

Please sign in to leave a comment.