1 Condition for Multiple Data Items

[bobj]

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.

[CognosPaul]

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

Code Select Expand

CallValue () < 0

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

[billylodz]

for fact cells use "Conditional Styles"

[bobj]

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

Any other ideas would be appreciated.