How to format the text with multiple conditions.

[Anonymous]

Hi

I have an expression in a straight table having the values like 0%,10,%,20% upto 240%.

I have to show 90 to 120% values are in Red color and other than this are in Green color.

Visual cues is only supporting two conditions, but how to give multiple conditions in expression attribute.

Can any one help me.

Thanks,Ravi

[bertinabel]

Que tal, Ravi.

     Ya intentaste desde las propiedades de la expresion en la opcion color de Texto, y ahi colocar la condicion con un IF, como a continuación te muestro en la imagen:

Saludos.

[krishna_2644]

Something like in below pic?

If so PSA

[varshavig12 · Accepted solution]

Properties--> Dimension --> Expression --> Text Color

If ( Your_exp > 90 or Your_exp <120 , red(), green())

[punitpopli]

you can use colormix() as well.

• Expand the expression
• Select text color
• expand expression window (i.e. "...")
• Select colormix wizard from file menu
• Enter the expression you want to evaluate (dont user "=" sign)
• Click next
• uncheck Auto Normalize and enter number/expression for upper and lower limit
• click next and finish, colormix expression will get generated
• validate the color coding in you expression

Hope this helps

[Anonymous]

Thanks Its working

[Anonymous]

Thanks for the help, it s working with the above expressions.

[punitpopli]

Hi,

Please mark the reply in above as helpful/correct answer to close the thread