Visual cue query

[#1]

Greetings all,

I have a chart where I wish to display conditional formatting based on another % field but with three options:

If  the total displayed in this field is greater than...sum({<Link_Date = {'40853'} >} SATS)/100.....display green

If it equals the same....display amber

If less than...display red

I normally use the Expression text colour for true/false but this obviously has a third option.

I have tried using the Visual cues and variations on the following

>= (sum({<Link_Date = {'40853'} >} SATS)/100)+1...

normal: sum({<Link_Date = {'40853'} >} SATS)/100...

<=  (sum({<Link_Date = {'40853'} >} SATS)/100)-1....

This is probably an easy fix but I cannot see it at the moment...

Thanks for any help

[#2]

Any ideas anyone?

In the meantime, I have used an Text Colour Expression

if(sum({< Link_Date = {'40944'} >}SATS)>sum({< Link_Date = {'40853'} >}SATS),lightgreen(),lightred())

but this will obviously highlight red where the total is the same on both days and I would like amber.

Is it possible to have more than 1 true/false statement on a Text Colour Expression?

[deepakk · Accepted solution]

Yes. Its possible.

Try thos out.

if(sum({< Link_Date = {'40944'} >}SATS)>sum({< Link_Date = {'40853'} >}SATS),lightgreen(),

If(sum({< Link_Date = {'40944'} >}SATS) =sum({< Link_Date = {'40853'} >}SATS), amber(),

lightred()))

Deepak

[#4]

Yes, that is a great help Deepak, thank you.