Print Page - Conditional Style on percent column [SOLVED]

Title: Conditional Style on percent column [SOLVED]
Post by: calson33 on 10 Oct 2013 05:52:38 PM

I tried applying a numeric range conditional style on a column that is formatted for percentages. However, nothing works - It always defaults to whatever style is applied to values less than the lowest comparison.

My styles are supposed to be applied like this:
[field] >= 100 - Green
[field]< 90 - Red
Everything else normal.

In that case, everything is red.
If I take out the <90, then everything is normal text.

It is never green, no matter how high the percentage numbers are.

Any idea on how to make this work?

Thanks!

EDIT- Ok, even weirder, I have similar conditional formatting on a percent column in a list on the very same report which works just fine. I suspect I am missing some very obvious.

Title: Re: Conditional Style on percent column [SOLVED]
Post by: calson33 on 10 Oct 2013 05:59:00 PM

User error.. :-[

The values are 1.00 = 100%, but I was looking for values between 90 and 100, instead of .9 to 1.0

Title: Re: Conditional Style on percent column [SOLVED]
Post by: Lynn on 11 Oct 2013 07:04:40 AM

Oh I've done that too!!

Title: Re: Conditional Style on percent column [SOLVED]
Post by: MFGF on 17 Oct 2013 05:27:48 AM

Yep - I've been there also. :)

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: calson33 on 10 Oct 2013 05:52:38 PM