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.