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

How to make a column with a null value hide the row?

Started by jon, 01 Mar 2010 03:06:04 PM

Previous topic - Next topic

jon

The subject sums it up.

I have a column of Current Fiscal YTD Quantity Sold and we're getting no data reported under certain SKUs. When there is no data in that column, I want to hide the row, so if there is no data reported, it will not show up at all.

I've tried [Current Fiscal YTD Quantity Sold] >=0, but it didn't do the job.

Thanks!

rcaesar

Hi Jon,

I think zero-suppression might work. Now, if a cell has null value, then you could convert that to a zero with
an If condition. Then you could apply zero suppression.

Is that what you are looking for ?

Best

paddhu

Which version of Cognos are you working in? With 8.4 suppression has been bettered and I suppose you can suppress rows with null with just a menu click.

jon

I'm working in 8.2 for this one. We have a seperate environment set up for one customer. I don't know why it hasn't been updated to 8.4, which is what our primary environment is running, but I have asked the question.

So, working in 8.2, how do I do this?

:)

Thanks!

vinu

Hi,

use below in your detail filter.

[Current Fiscal YTD Quantity Sold is not null

HTH,
Venu

jon

I finally got it. As ridiculous as it is, here's what I had to use:

[SD].[ POS Daily - Current Fiscal YTD].[Current Fiscal YTD Quantity Sold]is not missing or [ SD].[ POS Daily - Current Fiscal YTD].[Current Fiscal YTD Quantity Sold] is not null and [ SD].[ POS Daily - Current Fiscal YTD].[Current Fiscal YTD Quantity Sold] > 0 and [ SD].[ POS Daily - Current Fiscal YTD].[Current Fiscal YTD Quantity Sold] <> 0 and [ SD].[ POS Daily - Last Week].[Last Week Quantity Sold] <> 0 or [ SD].[ POS Daily - 2 Weeks Ago].[2 Weeks Ago Quantity Sold] <> 0

It took a lot of playing with the ands & ors to get it, but it is giving me what I was after. Only took me 3 days of testing to get it to work... :-\

paddhu

Gr8 work Jon. Appreciate your patience. Though it was forced unto you to come up with a solution.  ;)