0 Replies Latest reply: Jun 4, 2015 11:30 AM by Brian Dunphy RSS

    Colour KPI object based on prior year

    Brian Dunphy

      Hi,

       

      I have a KPI object which i want to display Current YTD Sales - with the smaller number showing Prior YTD Sales.

       

      I would also like to colour based on this calc. However - it will only allow a numeric to be entered in the limit.

       

      It is unlikely that i would like to change the colour or icon based on whether we sold > 2 million for example.

       

      I would like it to be dynamic and show based on the prior year so it would work for any selections.

       

      I realise i could limit to a % and use limits based on 0 --> 1 etc. but i would like to display the value.

       

      Is this possible ? Seems like basic enough functionality