Showing results for 
Show  only  | Search instead for 
Did you mean: 

Filter by NULL in Reports

I'm trying desperatly to filter a report by NULL-Values. I tried so far:

Like  !_*



Even if a column just contains three values (Active, Inactive and NULL) I was not successfull on filtering by:

Column <> *active  


AND NOT Column = *active.     In both cases I got no result back.


Regards Markus

(3) Replies

Hello Markus,


For help you, and to understand correctly, you try to filter a report directly on FNMS ? (All inventory for example) or on a DB , or another?


Best regards,


My bad, sorry, not see it's for spider.

Hi Markus,

He have a bug case open since 9th September and is with the developers. I have added you feedback to the bug case.


Like the answer, please remember to "Accept as solution". Keep the Kudo's coming!