6 Replies Latest reply: May 28, 2015 8:21 AM by Nandha Kumar RSS

    How to show the different colors according to the value displayed in a KPI???

    Nandha Kumar


      Hi All,

       

      I have a KPI value which change according to the filter selection. I want to show Red text if the value is below a range (i.e., 1,400,000) Green text if the value is above a range (i.e., 1,400,000). I tried the below expression in "Conditional Colors" of Max segment in Data tab. Can some one help me how to do this? Please refer the images

       

      If(Sum(ALLOCATION_COUNTER)>1,400,000,RGB(0,255,0),If(Sum(ALLOCATION_COUNTER)<0,RGB(255,0,0),RGB(0,0,255)))

       

      Pic1.png

       

      Pic2.png

       

      Regards,

      Nandha