Simple conditional formatting, but it does not work! Help!

[lorenmario]

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!

[lorenmario]

Print screen of conditional style.

[navissar]

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.

[anjidwh.cognos]

Hi,

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

Regards,
Ram

[lorenmario]

Hi friend!!!!!
I tried to do in several ways and nothing works, do not know what is happening ...

See the attached xml.

Thank you!!

[navissar]

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.

[lorenmario]

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!!!
;)

[lorenmario]

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 ...