Hi everyone,
I'm using the Multi-Row-Formula tool to calculate a moving average of headcount for a period of 6 days:
ROUND(
AVERAGE(
[Row-5:Headcount],
[Row-4:Headcount],
[Row-3:Headcount],
[Row-2:Headcount],
[Row-1:Headcount],
[Headcount]),
0.01)
That works without problem. But what do I do if I want to calculate the moving average for a period of 365 days? Do I really need to add 365 rows to the average function ([Row-364:Headcount] until [Headcount])? That would be extremely tiresome.
Is there a way to define a range for the average function, instead of defining every single entry?
Thanks a lot in advance!
Best,
Degas
Solved! Go to Solution.
Hi @Degas,
Did you follow @AngelosPachis tip to alter the version in a text editor? Did it work out for you :-)?! If not, let me know the Designer version you're running, i can post a version that should work for you.
@AngelosPachis thanks for helping @Degas out!
My macro is not the same as CharlieS's but i would say it's built on the same batch macro technique :-).!
Greetings,
Seb
Yes, it worked! Thanks a lot again to you both 😄