Average Dynamically

[Anonymous]

Hi All,

I have an issue to calculate average dynamically as Cummulative average at front end

PFA my sample file.

I have Year Month as dimension and sum(APE) as expression.

Now I want to calculate MAPE which is average of values calculated as cummulative summation.

MAPE CAlculation is >>

2014-01 = average(B$2)

2014-02 = average(B$2:B3)

2014-03 = average(B$2:B4)  ........................  and so on

Please help me in achieving it...

Year   Month	APE	MAPE
2014-01	65.00%	65.00%
2014-02	56.00%	60.50%
2014-03	86.00%	69.00%
2014-04	99.00%	76.50%
2014-05	164.00%	94.00%
2014-06	32.00%	83.67%
2014-07	143.00%	92.14%

[#2 · Accepted solution]

Hi Nitin,

Use this expression to calculate running average , i tried it and its working

=Num(RangeSum(Above(Sum(APE),0,RowNo()))/RowNo(),'#,##0.00')

I have also attached QVW, PFA

Regards,

Vivek

[jonathandienst]

Hi

Actually a little simpler:

     RangeAvg(Above(Sum(APE),0,RowNo()))

HTH

Jonathan

[#4]

Hi Try this

RangeAvg(Above(column(1),0,rowno()))

hope this will helps you