Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I have a below requirement that i want Growth % color in below format
(Single digit – black font, double digit – green font, de-growth – in red)
Thanks
Do you mean format of the numbers?
If Yes, in your expression "Text Color" option
=if(Num<0,RGB(255,0,0),if(Num<0.1,Black(),if(Num<1,GReen(),)))
Thanks Robert.
But i want to change symbol color which is present in Pink with respect number digit.
suppose 8----black
88--green
-8 --red
Thanks
Hi,
Please check the attached qvw.
Regards,
Jemimah
I Chime Robert way.
Try something like this.
Hi Jemimah,
I tried your formula but in my scenario but all values getting in red.
Hi,
Could you please post a sample qvw containing sample data.
Regards,
Jemimah
Hi Jemimah,
I am unable to send qvw file . give me another solution
Thanks
Hi,
Can you send some sample data around 5 rows of data ?