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

    Colour KPI object based on prior year

    Brian Dunphy



      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