color code changes

[prma7799]

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

[robert_mika]

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(),)))

[prma7799]

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

[#4]

Hi,

Please check the attached qvw.

Regards,

Jemimah

[hariprasadqv]

I Chime Robert way.

[ankit777]

Try something like this.

[prma7799]

Hi Jemimah,

I tried your formula but in my scenario but all values getting in red.

[#8]

Hi,

Could you please post a sample qvw containing sample data.

Regards,

Jemimah

[prma7799]

Hi Jemimah,

I am unable to send qvw file . give me another solution

Thanks

[#10]

Hi,

Can you send some sample data around 5 rows of data ?