Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I have a gauge chart with expression so same I have to show in table box with bg color
so how can I use?
expression I have placed in variable
vMyExpression =This expression is big so I want to use variable in bg colour
logic: 0-80% red, 80%-90% amber >90% green
Hi,
variable can not hold multiple values.If the expression is big you can perform the calculations at script level.
with your expression you can try something like below.
=if(vMyExpression>90,RGB(0,204,0),if(vMyExpression>=80 and vMyExpression<=90,RGB(255,255,0),if(vMyExpression<80,RGB(255,0,0))))
Thanks,
Pooja
Hi,
variable can not hold multiple values.If the expression is big you can perform the calculations at script level.
with your expression you can try something like below.
=if(vMyExpression>90,RGB(0,204,0),if(vMyExpression>=80 and vMyExpression<=90,RGB(255,255,0),if(vMyExpression<80,RGB(255,0,0))))
Thanks,
Pooja
Following may help
Relative Text Color expression
May be your vMyExpression evaluation is going wrong.
thanks its working now