Visual Alert using Text object

[#1]

Hi All,

We are calculating the conversion ratio in a text object, now the requirement is that

1. if the percentage is below or equal to 50, the text object should pop up red color.

2. If the percentage is greater than 50 but less than 70, the text object should pop up yellow color

3. If the percentage is greater than 70, the text object should pop up Green color.

We are using the following query in the the General -> text column of the Text object

=num((count(if(Conversion='Yes',Conversion)) / Count([Patient Code]) * 1),'##0 %;(##0)')

Thanks in Advance.

[tresesco]

Use calculated color for font.

[#3]

Hi Tres,

I am new to QV

Could you please let me know, which location or under which option will I get the calculated Color tab.

[tresesco]

Is this what you need?