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

Filter - numeric and string?

Started by fchickering, 04 Jan 2011 09:13:03 AM

Previous topic - Next topic

fchickering

I have a column of accounting codes (acct_code) that have numeric AND string values.  Can I create 1 filter that will select both?

Example:
7201
7216
721P
721Q
7300
7389

I want my syntax to be....((acct_code>=7200 and acct_code<=7400) or (acct_code =721P or acct_code=721Q)).  THis syntax does not work.....I must be missing some key part, or else perhaps it is not possible?
Thanks in advance.

sir_jeroen

change filter to ....((acct_code>='7200' and acct_code<='7400') or (acct_code ='721P' or acct_code='721Q')).  So add quotes!