COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: RiRo on 22 Feb 2018 09:46:47 AM

Title: Calculation for Conditional Style
Post by: RiRo on 22 Feb 2018 09:46:47 AM
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
Title: Re: Calculation for Conditional Style
Post by: BigChris on 22 Feb 2018 10:17:01 AM
You just need to fully qualify your condition:

Case
when [YourField] > 0 then Colour1
when [YourField] <= 0 then Colour2
when [Yourfield] is missing then Colour2
else Colour3
End
Title: Re: Calculation for Conditional Style
Post by: RiRo on 23 Feb 2018 02:07:50 AM
Is it possible to do this in the Conditional Styles tool or
do you use the Condition Explorer ?