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
Date
Votes
1 comment
-
Jet Reports Historic Posts If I understand you correctly, its quite simple:
=nl(……"State","<>@@&<>BLAH")
Will exclude blanks, and everything that is BLAH (presuming State is a valid field in your system).
Just remember that | is a logical OR operator, and & is the logical AND operator.
Please sign in to leave a comment.