Visual cues based on different field

[#1]

Hello

I have a table as follow

SN	System_Type	Labors
SN1	Type1	200
SN2	Type1	150
SN3	Type1	250
SN4	Type2	100
SN5	Type2	90

!

I would like to use Visual cues and change the color of labors as follow

• if System_type is Type1 than if sum_of_labors is > 210 it's red if lower green
• if System_type is Type2 than if sum_of_labors is > 95 it's red if lower green

thanks

Franck

[Agis-Kalogiannis · Accepted solution]

What I would suggest, is, instead of using Visual Cues, to use the expression attributes.

In front of every expression on the expressions tab, there is a small plus sign.

If you click on it, you can see the expression attributes.

Select the Text Color for the Labors expression and type the following expression:

if(System_Type='Type1' AND sum_of_labors>210, lightred(), green())

Thanks

Agis

[awhitfield]

HI franck,

you would be best using back ground colour formatting against your expression, see example attached.

This has as back ground colour expression of:

if(System_Type='Type1' AND sum(Labors>210), lightred(),
if(System_Type='Type2' AND sum(Labors>95), lightred(), LightGreen()))

On the Sum(Labors) expression that gives the following results:

HTH Andy

[#4]

Thanks you I use your recommandation

[#5]

Thank you