3 Replies Latest reply on Jan 6, 2017 8:37 AM by Elodie Quirin

    Average of different calculated field - rate calculated differently for KPIs

    Elodie Quirin

      Hello all,

       

      To begin, I wish you all an happy NEW YEAR 2017 !!

      I need help because I'm looking for a solution since 2 days, and I don't find how to calculate what I want.

       

      I want to calculate a global rate for my 5 KPI, with an exception for 1 of all my KPI.

       

      I want to do this :

      • RATE for my KPI 1, 2, 4 and 5   = SUM ([KPI Numerateur])/SUM([KPI Denominateur])*100
        • > This calculated field is OK for my KPI 1, 2, 4 and 5
        • > But I need exception for my KPI 3
      • For my KPI 3, I want to calculate the rate differently, so I create a calculated field like this :

      IF ATTR([Id Indicateur KPI]) = 3

      THEN (((SUM([KPI Numerateur])/[COUNT trigram BU])) / ((SUM([KPI Denominateur]) / [COUNT trigram BU])))*100

      END

       

      • At the end, I want to have a global rate for all my KPI 1, 2, 3, 4, and 5.
        And I don’t succeed to have the global average, because my KPI 3 is different.

       

      How can I do this ?

      Thank you for all your help.