Color Indications on new column.

[MuraliPrasath]

Hi QV Team,

I've Total License and Used License column. I need one more column indicates colors.

Ex:-    If my Used License is consumed 50% of the total License then GREEN Color.

          If 80% Consumed then YELLOW Color.

          If 100% Consumed then RED Color.

[maxgro · Accepted solution]

in a straighjt table you can try to add an expression ( '' )

and in  background color

if(column(2) = column(1), rgb(255,0,0),

if(column(2) >= column(1)*0.8, yellow(),

if(column(2) >= column(1)*0.5, rgb(0,255,0),

anothercolor

))))

you have to modify my example expression with your column and also change the math and color

[Anonymous]