-
1. Re: Average of different calculated field - rate calculated differently for KPIs
Elodie Quirin Jan 5, 2017 9:09 AM (in response to Elodie Quirin)To complete my need, I join you my Workbook with my calculated fields :
To do a global AVERAGE, I do like this :
First calculated field for my numerator calculated :
IF ATTR([Id Indicateur KPI]) = 3
Then (SUM([KPI Numerateur])/[COUNT trigram BU])
ELSE SUM([KPI Numerateur])
END
Second calculated field for my denomintor calculated :
IF ATTR([Id Indicateur KPI]) = 3
Then (SUM([KPI Denominateur])/[COUNT trigram BU])
ELSE SUM([KPI Denominateur])
END
And then, I do this :
([Numerateur calculé])/([Denominateur calculé])
But it doesn't work, because, when I bring all my values in my sheet, it just keeps the value for my KPI 1, 2, 4 and 5, but not for the 3.
Thank you a lot for your help.
Elodie
-
2. Re: Average of different calculated field - rate calculated differently for KPIs
Stephen Rizzo Jan 5, 2017 9:11 AM (in response to Elodie Quirin)Hi Elodie,
It is hard to help because we cannot see what your data looks like. Why wouldn't the following work?
IF ATTR([Id Indicateur KPI]) = 3
THEN SUM ([KPI Numerateur])/SUM([KPI Denominateur])*100
ELSEIF ATTR([Id Indicateur KPI]) = 1 OR ATTR([Id Indicateur KPI]) = 2 OR ATTR([Id Indicateur KPI]) = 4 OR ATTR([Id Indicateur KPI]) = 5
THEN (((SUM([KPI Numerateur])/[COUNT trigram BU])) / ((SUM([KPI Denominateur]) / [COUNT trigram BU])))*100
END
-
3. Re: Average of different calculated field - rate calculated differently for KPIs
Elodie Quirin Jan 6, 2017 8:37 AM (in response to Stephen Rizzo)Hi Stephen,
Thank you for your help. I've resolved my problem.
Thank you,
Elodie