Print Page - Filtering Data Values

Title: Filtering Data Values
Post by: LOUM on 27 Jul 2011 10:27:37 AM

Ok I apologize for this but I am having a brain block here.

I have a report which I want to filter my data value it is as follows:

Code:
000000
100000
200000
300000
400000
500000
600000

I want to filter out less than 100000, then filter out 200000 and 400000. Whats the best solution?

Code Select

 => 099999 and < 200000, i'm lost.

Thank you,
Lou

Title: Re: Filtering Data Values
Post by: MFGF on 28 Jul 2011 06:58:49 AM

Hi,

You could try...

(

Code Select

 between 100000 and 199999) or ([Code] between 200001 and 399999) or ([Code] > 400000)

Regards,

MF.

Title: Re: Filtering Data Values
Post by: LOUM on 09 Aug 2011 03:44:10 PM

Thank you. 8)

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: LOUM on 27 Jul 2011 10:27:37 AM