Conditional formatting in rounded values -
facing trouble in cognos 10, in report have apply conditional formatting values less 0 (except zero) red, applying round-off 0 decimals. problem values -0.1 getting rounded-off 0 , shown in red due conditional formatting. is there work around show rounded 0 values in black? try rounding off value on condition on conditional style too. these: round(([columnvalue]*100),0) < 0 then set foreground color or background color red. hope helps.