Applying RGB to a value in Text Object

[#1]

Dear All,

Scenario:

A text object contains a value. If value is greater than Zero(0) the value should be in green otherwise in red.

EX: if(value>0,'value in Green Color','Value in Reg Color')

Thanks in Advance

[robert_mika]

maybe:

=if(Value>0,Green(),Red())

Go to Background-Color-Calcualted and put your expression there:

Let say:

=if(max(Amount)>0,Green(),Red())

[datanibbler]

Hi Praful,

you can use the RGB() function to specify colours. You can expand any of the expressions in your chart and specify some options, among them the background_colour. There you will have to enter it in $()

=> That would be >>  $(RGB(0,0,0))  <<<

To keep the colouring consistent between your apps, you could define a colour_palette in a qvs and use that instead of individually specifying the colours every time.

HTH

Best regards,

DataNibbler

[rubenmarin1 · Accepted solution]

Hi Praful, in Font tab-->click on the "color", select 'Calculated' and set the expression, something like:

If(value>0, Green(), Red()) --> You can especify a RGB color like this:

If(value>0, RGB(0,255,0), RGB(255,0,0))

Change 'value' for the expression you use in the text object, in example, if value is =Sum(Sales), the color expression should be:

If(Sum(Sales)>0, Green(), Red())

[#5]

Hai Robert,

Thanks for the reply.

But my need is to make a value in text object either in red or green color according to the condition

Thanks

[#6]

Thank you Ruben