COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: vivek_vdc on 06 May 2016 04:18:17 PM

Title: Displaying Negative Numbers in RED
Post by: vivek_vdc on 06 May 2016 04:18:17 PM
I have a list report with 20 measures - the measures are dollar values, percentages and counts - some are calculated and others are directly sources from the package.

I want to display negative numbers in RED for the measures only if the measure value is lower then zero. Do I have to create 20 different conditional styles - one for each measure that states if measure < 0 then RED or is there an easier technique.
Title: Re: Displaying Negative Numbers in RED
Post by: schrotty on 07 May 2016 03:00:13 PM
Hi,

Try "CellValue()". You can use the same conditional style for every of your 20 measurs.

Schrotty