Runningaverage 10 weeks

[former_member204983]

Hi,

I have year-week dimension and actuals for each month.

Runningsum on week-to-week basis works fine

with: =RunningAverage([Query 365].[1 Incident count])

I would like to have a runningsum counted on 10 weeks period.

Webi 4.2 SP3

/Henrik

[former_member204983]

Sorry, I have of course actuals for each week!

[former_member204983]

Look's fine! The data for week 1-9 is hidden by checking the weeknumber for week-10w, or actually hide week 1-9 by checking if week previous 10w is null. Thank you again!

[Former Member]

Excellent. Glad it worked.

[former_member204983]

Hi,

Thank you, it works i guess. Have to double check. The ugly part is that it calculates a value at week 1-9 and of course dousens give correct answer. But it is a good start.

Thank you!

Br,

Henrik

[Former Member]

A little ugly, but try:

=([Query 365].[1 Incident count]+Previous([Query 365].[1 Incident count];1)+Previous([Query 365].[1 Incident count];2)+Previous([Query 365].[1 Incident count];3)+Previous([Query 365].[1 Incident count];4)+Previous([Query 365].[1 Incident count];5)+Previous([Query 365].[1 Incident count];6)+Previous([Query 365].[1 Incident count];7)+Previous([Query 365].[1 Incident count];8)+Previous([Query 365].[1 Incident count];9))/10