6 Replies Latest reply: Jul 31, 2014 2:36 AM by Mafaz Jaufer

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

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

• ###### Re: How to color column in straight table when value is high or low?

Try something like this...

Properties-->Visual  Queues

Enter the max/min values,  based on the requirement

• ###### Re: How to color column in straight table when value is high or low?

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

• ###### Re: How to color column in straight table when value is high or low?

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.

• ###### Re: How to color column in straight table when value is high or low?

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.

• ###### Re: How to color column in straight table when value is high or low?

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)))