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