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

    background colour of expression

    Rhona Corcoran

      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
          bobbyraj santhiogu

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