If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Null

Started by jrygiel, 27 Mar 2017 03:30:14 PM

Previous topic - Next topic

jrygiel

We have several reports that we use is/is not null in, however, in one of our current reports the information only shows up when we put IS NULL instead of IS NOT Null. 

HELP!

BigChris

Depending on what you're doing, I tend to use "is missing" and "is not missing"

AnalyticsWithJay

Quote from: jrygiel on 27 Mar 2017 03:30:14 PM
We have several reports that we use is/is not null in, however, in one of our current reports the information only shows up when we put IS NULL instead of IS NOT Null. 

HELP!

If you view the tabular data, do you see nulls? Export to excel to see the entire tabular data set and check for nulls.

Is this a crosstab or chart? I wonder if you're seeing nulls because of an OLAP query.

Is this OLAP, relational, DMR?