COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: snowy on 14 Aug 2013 06:17:05 AM

Title: % is not a special character
Post by: snowy on 14 Aug 2013 06:17:05 AM
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?
Title: Re: % is not a special character
Post by: Lynn on 16 Aug 2013 07:48:17 AM
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.