I am trying to refer to a minimum value of a calculated KPI and calculate another KPI.
In this case I am looking at minimum cost and calculating Potential savings.
Is there a way to do this? the min function only works on columns as far as i know
Actually you could use MIN for KPI’s as well. Just keep an eye on using aggregations not in the KPI itself.
This works, when there is no aggregation in the KPI: