Skip to main content
Question

Referencing minimum value of calculated KPI

  • August 27, 2020
  • 1 reply
  • 24 views
.
Level 1
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

1 reply

A
Level 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: MIN(KPI("NEW_SAVED_FORMULA")) Best regards
Community Code of ConductAccessibility statement