COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: jrygiel on 27 Mar 2017 03:30:14 PM

Title: Null
Post by: 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!
Title: Re: Null
Post by: BigChris on 28 Mar 2017 01:58:30 AM
Depending on what you're doing, I tend to use "is missing" and "is not missing"
Title: Re: Null
Post by: AnalyticsWithJay on 28 Mar 2017 07:38:57 AM
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?