Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
using a button to show a numerical KPI.
I want colour to change according to an expression.
Trying different option, but none although syntax correct, do not show correct colour.
Any ideas?
These are the expression I am trying:
=if((Avg([apsys_score]) >= 0.00) and (Avg([apsys_score]) < 1.00), RGB(187,42,24),
if((Avg([apsys_score]) >= 1.01) and (Avg([apsys_score]) < 2), RGB(255,118,33),
if((Avg([apsys_score]) >= 2.01) and (Avg([apsys_score]) < 3), RGB(255,207,2),
if((Avg([apsys_score]) >= 3.01) and (Avg([apsys_score]) <= 5), RGB(39,110,39))
)
)
)
or
=if(([apsys_score]) < 1.00, RGB(187,42,24),
if(([apsys_score]) < 2, RGB(255,118,33),
if(([apsys_score]) < 3, RGB(255,207,2),
if(([apsys_score]) <= 5, RGB(39,110,39))
)
)
)
Any ideas or suggestions?
Thanks
hi @JoseGarcia
try:
=if(AVG([apsys_score]) < 1, RGB(187,42,24),
if(AVG([apsys_score]) < 2, RGB(255,118,33),
if(AVG([apsys_score]) < 3, RGB(255,207,2),
if(AVG([apsys_score]) <= 5, RGB(39,110,39))
)
)
)
also remember you can use color names, blue(), red(), yellow() or better ARGB codes for opacity
best,
help users find answers! Don't forget to mark a solution that worked for you & to smash the like button!
hi @JoseGarcia
try:
=if(AVG([apsys_score]) < 1, RGB(187,42,24),
if(AVG([apsys_score]) < 2, RGB(255,118,33),
if(AVG([apsys_score]) < 3, RGB(255,207,2),
if(AVG([apsys_score]) <= 5, RGB(39,110,39))
)
)
)
also remember you can use color names, blue(), red(), yellow() or better ARGB codes for opacity
best,
help users find answers! Don't forget to mark a solution that worked for you & to smash the like button!