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!
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
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.
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!
Hi,
use below in your detail filter.
[Current Fiscal YTD Quantity Sold is not null
HTH,
Venu
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... :-\
Gr8 work Jon. Appreciate your patience. Though it was forced unto you to come up with a solution. ;)