0 Replies Latest reply: Nov 19, 2015 4:58 AM by Rhona Corcoran RSS

    background color in expression

    Rhona Corcoran

      Hi

       

      I have the following expression in background colour of an expression in a chart it works fine but I want it to only show for 2015 on and to have a white background for 2014 as the variable it is measuring against wasn't there for 2014.

       

      Any help appreciated

       

       

       

      if(num(Sum({$<[GenAdult]={5,6,7,8,9,10,11,12,13,14,15,16,19,20,21,22,23,24,25,26,27,28,29,30,33,34,35,36,37,38,39,40,41,42,43,44,47,48,49,50,51,52,53,54,55,56,57,58}>}ActualValue)/
      (
      Sum({$<[GenAdult]={5,6,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,47,48,49,50,51,52,53,54,55,56,57,58,59,60}>}ActualValue)), '##0%')>=[vtarget MH1 5%],RGB(81,173,152),
      if(num(Sum({$<[GenAdult]={5,6,7,8,9,10,11,12,13,14,15,16,19,20,21,22,23,24,25,26,27,28,29,30,33,34,35,36,37,38,39,40,41,42,43,44,47,48,49,50,51,52,53,54,55,56,57,58}>}ActualValue)/
      (
      Sum({$<[GenAdult]={5,6,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,47,48,49,50,51,52,53,54,55,56,57,58,59,60}>}ActualValue)), '##0%')<[vtarget MH1 10%],RGB(208,62,81),
      if(num(Sum({$<[GenAdult]={5,6,7,8,9,10,11,12,13,14,15,16,19,20,21,22,23,24,25,26,27,28,29,30,33,34,35,36,37,38,39,40,41,42,43,44,47,48,49,50,51,52,53,54,55,56,57,58}>}ActualValue)/
      (
      Sum({$<[GenAdult]={5,6,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,47,48,49,50,51,52,53,54,55,56,57,58,59,60}>}ActualValue)), '##0%')>=[vtarget MH1 10%] and
      num(Sum({$<[GenAdult]={5,6,7,8,9,10,11,12,13,14,15,16,19,20,21,22,23,24,25,26,27,28,29,30,33,34,35,36,37,38,39,40,41,42,43,44,47,48,49,50,51,52,53,54,55,56,57,58}>}ActualValue)/
      (
      Sum({$<[GenAdult]={5,6,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,47,48,49,50,51,52,53,54,55,56,57,58,59,60}>}ActualValue)), '##0%')<[vtarget MH1 5%],RGB(233,174,17))))