How to color column in straight table when value is high or low?

[#1]

Hi,

I have added below query to make "RED" if plan is more than actual and if actual is more than plan "GREEN"

if(Avg([Plan PSD_FM])> Avg([Actual PSD_FM]),RGB(255,99,71),RGB(50,205,50))

but in 0 its shows "GREEN" I want to make it "WHITE" in 0. please find the image in the attachment

[PradeepReddy]

Try something like this...

Properties-->Visual  Queues

Enter the max/min values,  based on the requirement

[#3]

I can't do so because is a comparison and plan and actual values get changes time to time

so I can't set a exact value   

[Anonymous]

Olá, Tenta isso

if(Avg([Plan PSD_FM])> Avg([Actual PSD_FM]),RGB(255,99,71),if(Avg([Plan PSD_FM])< Avg([Actual PSD_FM]),RGB(50,205,50),White()))

Abs.

[fernando_tonial]

You should put this calculation in every expression on the background color by clicking on the plus side of the expression.

Background Color Expression:

if(Avg([Plan PSD_FM]) > Avg([Actual PSD_FM]),RGB(255,99,71),if(Avg([Plan PSD_FM]) = 0 or IsNull(Avg([Plan PSD_FM])) , RGB(255,255,255), RGB(50,205,50)))

Best Regards.

Tonial.

[rphpacheco]

Try:

if(Avg([Plan PSD_FM]) > Avg([Actual PSD_FM]),RGB(255,99,71),if([Plan PSD_FM] = 0, RGB(255,255,255), RGB(50,205,50)))

[#7 · Accepted solution]

Correct Answer

If(Avg([Plan GRN Hit Rate_STORES])>Avg([Actual GRN Hit Rate_STORES]), RGB(255,99,71),

If(Avg([Plan GRN Hit Rate_STORES])<=Avg([Actual GRN Hit Rate_STORES]), RGB(50,205,50), White()))