4 Replies Latest reply on Oct 3, 2016 5:53 AM by Luciano Vasconcelos

    Conditional Formatting/ KPI

    alex lewis

      Hi,

       

      Below is a KPI I created showing quarter on quarter changes, where increase in figures adopt a purple text  and an and orange text and an for decrease, however, the downward arrow also appears when the figure shows no change, as highlighted below. I want to add a further condition showing no change, with a different colout and an ▶.

       

      The formula used for the above is listed below;

       

      if INDEX () = 1 then

      ""

      ELSE

      if sum([HC & FTE Breakdown]) >= Lookup (sum([HC & FTE Breakdown]), -1) then

      ""

      ELSE

      ""

      END

      END