10 Replies Latest reply: Jun 21, 2017 11:31 AM by Tanguy de Becdelievre RSS

    Kpi problem - need help to find correct formula

    Tanguy de Becdelievre

      Hi Everybody,

       

      I am facing some problem getting the KPI I want.I need to find the correct formula to get the following KPI:

       

      What is the area with an average yield above 90 ?

       

      Here is my data sample:

      8fed0c28d34c4f959d4177408f838ef0.png

      By sorting with the highest yield on the top in a table, and then calculating the cumul yield and area, I find easily the correct answer, which is in this case 124.6.


      Does anyone know how to get this value directly in a KPI ?


      Thank you for your help,

      Regards,

      Tanguy