table text color


I need help with the colour coding on the table.

I have values 7 columns in the data table. ( string and numeric form)

I want to display all columns in red colour in value in the specific column is 0).


I'm using Spotfire 7.6





1 Comment

Hi Rohit,

1. Create one calculated column -> Find(",0",Concatenate([col1],",",[col2],",",[col3],",",[col4],",",[col5])) name this as FIND_ZERO

2. Go to table color properties and Create Color Scheme Grouping for string and numeric types.

3. For each color grouping add rule for boolean expression -> [FIND_ZERO]>0 make this rule for red color.
Murari K - Apr 06, 2018 - 12:05am ::
+ Add a Comment

(1) Answer