2 Replies Latest reply: Jul 1, 2016 8:05 AM by Liron Baram RSS

    How to use Conditional Colours option in the KPI Object for simple CYTD vs LYTD comparision?

    John Blomqvist

      Hi All,

       

      I have the following Expression in the KPI Object:

       

      Sum({<CurYTDFlag={1}>}Sales)

       

      How can I use Conditional Colours to change the output of the KPI so that if Sales for Current Year are higher than Last Year, then it must be Green, otherwise Red.

       

      CYTD Sales: Sum({<CurYTDFlag={1}>}Sales)

      LYTD Sales: Sum({<LastYTDFlag={1}>}LineSalesAmount)

       

      How do I need to configure the Conditional Colours for this?