Calculatuing Average

[#1]

Hi,

I have got large amount of data which looks something like this

example:

Kpi             Location          numerator      Denominator

1                 London               3                     5

1                 Essex                4                     8 

1                 Sussex              5                     2

1                 Newcastle          7                     4                          

1                  Oxford               2                    4  

I have created a Bar chart with Location on X axis and and percentage on Y axis.

Percentage is calculated by (Numerator/denominator)*100

I am looking to calculate the AVERAGE and display it in a text box under the chart wrt to KPI 1.

Can I get some help for this please.

[Anonymous · Accepted solution]

This should do the trick:

=avg(numerator/denominator)*100

For targetting only Kpi=1, use:

=avg({$<Kpi={1}>} numerator/denominator)*100

[#3]

Thanks Johannes Sunden. That was of much help.

Regards,

K.V