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. 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.