How can I calculate the MM4 ?

[suzel404]

Hi all,

How can I calculate the Moving Average of type 4 dynamically:

MM4 = 1/4[(1/2 Q1-2011) + Q2-2011 + Q3-2011 + Q4-2011 + 1/2(Q1-2012)]

Thanks for your help.

[maxgro]

maybe

0.25*

rangesum(

     0.5*Above(total Sum(SALESINCOME), 2),

     Above(total Sum(SALESINCOME), 1),

     Sum(SALESINCOME),

     Below(total Sum(SALESINCOME), 1),

     0.5*Below(total Sum(SALESINCOME), 2)

)

[petter · Accepted solution]

Above(TOTAL Sum(SALESINCOME),2)/2+RangeSum(Above(TOTAL Sum(SALESINCOME),0,2))+Below(TOTAL Sum(SALESINCOME))+Below(TOTAL Sum(SALESINCOME),2)/2

[suzel404]

Many thanks for your help guys!!