Back ground colour based on couple of condition

[nevilledhamsiri]

As per the attached table, the variance created in the front end to be given with back ground colour as follows

If the variance is less than 0, & until the variance go over -5000, it should be given with green colour. Also if the variance is more than  0 & until it goes up to +5000, it should be given with green colour & anything over or below (+5000,-5000) with green.

If I am sent with the expression this is mostly welcome.

Thanks in advance.

Neville

[nevilledhamsiri]

Sorry the colour which does not within that range should be in Red. Sorry for printing error

[sangeess21]

Did you mean if variance is between (-5000,5000) green and anything outside this range as red? If yes, please refer the attached file.

[nevilledhamsiri]

Could you please send me the expression. Cannot open your file as long as I have personnel edition

[sangeess21 · Accepted solution]

Add this expression under Expression/Background color.

if(SUM({<BRANCH={'RA','EH','K7','K9','EM','AS','TA'}>}VARINACE)>5000 or SUM({<BRANCH={'RA','EH','K7','K9','EM','AS','TA'}>}VARINACE)< -5000,LightRed(),LightGreen())

[nevilledhamsiri]

Thanks Sangeetha, This is what I looked forward to.

Neville

[MarioCenteno]

Try

expression background color

If( Column(3)>5000 and Column(3) <-5000, RGB(0, 255, 0),

If( Column(3)>=0 and Column(3) <5000 , RGB(0, 244, 0),RGB(255,0,0)))