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
Page 1 / 1
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:
Best regards
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 regards
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.