Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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% |
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
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
Hi
Actually a little simpler:
RangeAvg(Above(Sum(APE),0,RowNo()))
HTH
Jonathan
Hi Try this
RangeAvg(Above(column(1),0,rowno()))
hope this will helps you