Question
Referencing minimum value of calculated KPI
Hello,
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
Hey,
Actually you could use MIN for KPIs as well. Just keep an eye on using aggregations not in the KPI itself.
This works, when there is no aggregation in the KPI:
MIN(KPI("NEW_SAVED_FORMULA"))
Best regardsEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.