COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: lorenmario on 16 Dec 2013 11:13:15 AM

Title: Simple conditional formatting, but it does not work! Help!
Post by: lorenmario on 16 Dec 2013 11:13:15 AM
Hi friends,
I have a problem to apply simple conditional formatting in two fields in my report, I've tried everything and just does not work!

The report contains seven indicators, and all need conditional formatting to show when the value is less than -5%, or greater than 5%.

Applied formatting using that shortcut with the right mouse button -> style -> conditional styles.

In five indicators works perfectly, only in Households and Trips does not work, do not understand why, I tried to make a string variable and apply only these two lines, but also does not work.

Please find attached the report screen, and image formatting that I applied ...

I appreciate if you help me!
Thank you!
Title: Re: Simple conditional formatting, but it does not work! Help!
Post by: lorenmario on 16 Dec 2013 11:14:34 AM
Print screen of conditional style.
Title: Re: Simple conditional formatting, but it does not work! Help!
Post by: navissar on 17 Dec 2013 01:44:01 AM
Hi there,
This looks like an interesting issue! I would love to see the report XML so I can understand how you set the conditional up precisely, maybe we'll be able to find a solution.
Title: Re: Simple conditional formatting, but it does not work! Help!
Post by: anjidwh.cognos on 17 Dec 2013 03:13:28 AM
Hi,

Are u applying conditional formatting before or after cal of % value?

Regards,
Ram
Title: Re: Simple conditional formatting, but it does not work! Help!
Post by: lorenmario on 17 Dec 2013 06:25:29 AM
Hi friend!!!!!
I tried to do in several ways and nothing works, do not know what is happening ...

See the attached xml.

Thank you!!
Title: Re: Simple conditional formatting, but it does not work! Help!
Post by: navissar on 17 Dec 2013 07:13:57 AM
Wow, this is horrible.
The only guess I have after a quick look is that this may have to do with the changed solve orders. For all the rest, solve order is 2. Also, I'd try to have IBM support involved, because this is horrid.
Title: Re: Simple conditional formatting, but it does not work! Help!
Post by: lorenmario on 17 Dec 2013 07:30:08 AM
Hi friend,

Is it because I changed the solve order of field? The calculation is only correct when I set the solve order ...

I change the propertie solve orders of all calculated field for 2, run the report and it did not work ...

I do not know what else to do ...

Any more suggestions?
Tks!!!
;)
Title: Re: Simple conditional formatting, but it does not work! Help! SOLVED
Post by: lorenmario on 18 Dec 2013 12:07:47 PM
Hi all,
I solved the problem simply edited the column that the formatting was not working, so:
[field] * 1

it worked! Do not ask me why ...