Straight table background color

[deepakkrish]

Hi All ,

I am using 2 dimensions and 3 expressions in straight table . My requirement is to change the back ground color based on condition . Can anyone help me to done this .

Dim: Month, Timestamp

Score : 

=if(score<=2.5,red(),
if(score>=3.5,green(),Yellow()))

percentage:

=if(percentage<='80%',red(),

if(percentage>='95%',green(),yellow()))

Regards,

Deep.

[Lisa_P]

If score and percentage are fields, you need to aggregate - sum(score) ..

If they are column names in the table, it should work out ok.

[deepakkrish]

That is not a filed name just a calculation..

[deepakkrish · Accepted solution]

The expression and condition is correct .

back ground color transparency should be 0% . It working now.

Thanks,

Deep.