I am trying to create a condition on my OLAP report. I want to display information when the Revenue source is not NULL. In the report output, the value is displayed as ".". I have tried specifying the condition as: When RevenueSource <> (.,".",NULL, ," ","",etc.) but haven't been able to filter Revenue Sources with "." out.

Does anyone know how to fix this issue?

This message has been edited. Last edited by: Kerry,

. is the display value.
The FOCUS keyword for SQL NULL is MISSING.
WHERE field EQ MISSING ;

Also don't use <>, use NE.

And if you ever want to check a list, use WHERE FIELD IN (item1,item2,itemn) or WHERE NOT FIELD IN (item1,item2,itemn). MISSING cannot be in this list, it must be by its self.

Thanks guys. "MISSING" worked just fine.