Average at Script Level

[#1]

Hello,

How to calculate 5 week rolling average at the script level using RangeAvg function.

Attaching excel file for your reference.

[swuehl · Accepted solution]

LOAD [Fiscal Week Ending],

     Amount,

     [5 Week Rolling Avg],

     rangeavg(

               Amount,

               peek(Amount,-1),

               Peek(Amount,-2),

               peek(Amount,-3),

               peek(Amount,-4)

                                                       ) as myRollingAvg

FROM

(biff, embedded labels, table is Sheet1$);

Hope this helps,

Stefan

[#3]

Dear Stefan,

This is great. Helped me a lot.

Thanks a lot for your reply.

Nassar