COGNOiSe.com - The IBM Cognos Community

Hi,

I have a crosstab with approximately 50 data items.
For each data item which is a negative value I want the crosstab to show the value as red.
I can do this in the Conditional Explorer but I will have to do this for each of the 50 data items seperatly.

Is there a way of creating one condition and applying to all data items rather than creating 50 seperate conditions.

Thanks,
Imran.

I don't remember if this will work on previous versions, but on 8.4 you can do the following: Use a Boolean variable. Name it CellIsNegative. Use the formula CallValue () < 0

Right click on the crosstab and Select Fact Cells. From there use the style variable.

for fact cells use "Conditional Styles"

Thanks for the suggestion but the 'CallValue' function is not recognised in 8.1

Any other ideas would be appreciated.