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

% is not a special character

Started by snowy, 14 Aug 2013 06:17:05 AM

Previous topic - Next topic

snowy

Hello all,

I'm trying to build a conditional style which formats line items as percentage if they have a % in their name. So my first attempt was:

[Line Item] contains '%'

..but of course the % is a wildcard and lets any characters through, so it's as useful as a chocolate teapot.

So can anyone tell me how to denote % is a piece of text and NOT a special character?

Lynn

Try using '\%'

I tried this using the sample package to filter for product descriptions that contain % and it works for me. See attached for the report spec.