2 Replies Latest reply: Nov 23, 2015 10:36 AM by Rhona Corcoran

# background colour of expression

Hi I have the following expression in the background colour of an expression to show red, amber or green but I want the background to be white if the year is <2015.

would be grateful for help

thanks

if(num(Sum({\$<[CAMHS]={8,10,12,14,16,18,20,22,24,26,28,30,32,34,36,38,40,42,44,46}>}ActualValue)/
(
Sum({\$<[CAMHS]={7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46}>}ActualValue)), '##0.0%')<'10.50%',RGB(81,173,152),

if(num(Sum({\$<[CAMHS]={8,10,12,14,16,18,20,22,24,26,28,30,32,34,36,38,40,42,44,46}>}ActualValue)/
(
Sum({\$<[CAMHS]={7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46}>}ActualValue)), '##0.0%')>'11.0%',RGB(208,62,81),

if(num(Sum({\$<[CAMHS]={8,10,12,14,16,18,20,22,24,26,28,30,32,34,36,38,40,42,44,46}>}ActualValue)/
(
Sum({\$<[CAMHS]={7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46}>}ActualValue)), '##0.0%')>='10.51%' and

num(Sum({\$<[CAMHS]={8,10,12,14,16,18,20,22,24,26,28,30,32,34,36,38,40,42,44,46}>}ActualValue)/
(
Sum({\$<[CAMHS]={7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46}>}ActualValue)), '##0.0%')<='11.0%',RGB(233,174,17))))

• ###### Re: background colour of expression

HI,

Just add the condition for the year:

If(Year<2015,white(),

if(num(Sum({\$<[CAMHS]={8,10,12,14,16,18,20,22,24,26,28,30,32,34,36,38,40,42,44,46}>}ActualValue)/
(
Sum({\$<[CAMHS]={7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46}>}ActualValue)), '##0.0%')<'10.50%',RGB(81,173,152),

if(num(Sum({\$<[CAMHS]={8,10,12,14,16,18,20,22,24,26,28,30,32,34,36,38,40,42,44,46}>}ActualValue)/
(
Sum({\$<[CAMHS]={7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46}>}ActualValue)), '##0.0%')>'11.0%',RGB(208,62,81),

if(num(Sum({\$<[CAMHS]={8,10,12,14,16,18,20,22,24,26,28,30,32,34,36,38,40,42,44,46}>}ActualValue)/
(
Sum({\$<[CAMHS]={7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46}>}ActualValue)), '##0.0%')>='10.51%' and

num(Sum({\$<[CAMHS]={8,10,12,14,16,18,20,22,24,26,28,30,32,34,36,38,40,42,44,46}>}ActualValue)/
(
Sum({\$<[CAMHS]={7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46}>}ActualValue)), '##0.0%')<='11.0%',RGB(233,174,17)))))

• ###### Re: background colour of expression

Thank you so much. that worked fine.