Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
How can i change COLOR AREA of mini chart based on expression? My expression is like
=IF(($(TESTE_SINAL))<0, Green(), Red())
TESTE_SINAL can be between -1 and 1. But the color always return GREEN().
Sds
Hello,
please try,
=IF(($(TESTE_SINAL))<0, Green(), IF(($(TESTE_SINAL)>0,Red())
nested IF, you can use any number of them according to the requirement.
Hope this helps.
Mady
Hello,
I appreciated your help, but don´t work yet...
:-((
Sds
have you tried this?
=IF(($(TESTE_SINAL))<'0', Green(), Red())
Yes, i tried it too..
And i created a variable like
IF($(TESTE_SINAL)<0, Green(), IF($(TESTE_SINAL)>0,Red() ) ) l
and it return RGB(0,128,0) or RGB(128,0,0).
Bun in Chart, only draw green color....
I tried another way...
I used that variable create before as column on table and drow the color on cell backgroud, and works fine.
The problem is only mini chart bar...