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

Filtering Data Values

Started by LOUM, 27 Jul 2011 10:27:37 AM

Previous topic - Next topic

LOUM

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?    => 099999 and < 200000, i'm lost.

Thank you,
Lou

MFGF

Hi,

You could try...

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

Regards,

MF.
Meep!

LOUM