Font Colour Expression

[#1]

Good Morning

Please could someone assist me with conditional colour formatting of text within a table.

The columns expression is

round(Sum (totalinvlinevalue*invnewproduct)/Sum (totalinvlinevalue),0.03)

What I require is that if the result is 15% or LESS text to be RED and if not GREEN.

Thank you

Emma

[settu_periasamy]

Try like the below screen shot

[MK_QSL]

IF(NUM(Sum (totalinvlinevalue*invnewproduct)/Sum (totalinvlinevalue),#0.00%)<='15%', RED(),GREEN())

[#4]

Click on + sign in expressions under chart properties, then in Text Color  update your condition. Something like this if(round(Sum (totalinvlinevalue*invnewproduct)/Sum (totalinvlinevalue),0.03)<=0.15,red(),green())

[#5]

Manish

I get an error with this as

Bad field name #0.00%

[#6]

Try '#0.00%' in commas

[MK_QSL · Accepted solution]

IF(NUM(Sum (totalinvlinevalue*invnewproduct)/Sum (totalinvlinevalue),'#0.00%')<='15%', RED(),GREEN())

[#8]

I have tried this and its states expression ok - however all my text is red - even over 15 ?

[#9]

I  have input as 0.15 and it is working perfectly

THANK YOU TO YOU ALL

[#10]

thanks for all your help and support