Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))))
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)))))
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)))))
Thank you so much. that worked fine.