3 Replies Latest reply: Dec 20, 2017 5:39 AM by omar bensalem RSS

    Set KPI limit that changes color based on comparison

    Stijn Valkenburg

      Hi all,

       

      So I have a KPI like the one below:

       

      Here the largest value is my CYTD Sales and the smaller value is the LYTD Sales. Now I want to set a limit and set colors as follows:

      -- If CYTD is larger then LYTD it should be green and LYTD should be red

      - If LYTD is larger that CYTD it should be green and CYTD should be red

       

      I can't use rgb codes combined with an if statement in this case so I am wondering how to set the limit..

       

      Thanks in advance!