Calculation for Conditional Style

[RiRo]

Hi Community!

I have a Problem with a conditional style.
I calculate two values, if positive integer then true else false.
Sometimes it happens, that a value is missing and the calculation fail.

Is there a way to tell cognos, if a failure Comes up, then use this colour?

Thank
Rob

[BigChris]

You just need to fully qualify your condition:

Code Select Expand


Case
when [YourField] > 0 then Colour1
when [YourField] <= 0 then Colour2
when [Yourfield] is missing then Colour2
else Colour3
End


[RiRo]

Is it possible to do this in the Conditional Styles tool or
do you use the Condition Explorer ?