3 Replies Latest reply: Aug 1, 2018 8:22 AM by Robin Heijt RSS

    Color expression in if statement along with condition in kpi

    Deepak K M

      Attached is a sample excel sheet,

      i want a value in red and green color in the KPI,

      I'm using the below expression to achieve the same,  but not finding the result.

      if(E<0,-(E) and red(), 0 and green())

       

      What i'm trying is , if the value of E is less than zero or negative, i am making E positive and i want that to be in red() color and if the value of E is greater than or equal to zero and positive i'm making E to be Zero and i want that to be in green(). but the above expression yields - sometimes.

      can anyone help me out stalwar1Screenshot (53).png