Forum Discussion

Tazmastablasta's avatar
Tazmastablasta
Icon for Helper I rankHelper I
7 years ago

3 month rolling average with Last Value

Hi all   This is my problem.  I am trying to calculate 3 month avarge every month (rolling) with last value.   For exmaple    ID   SCORE DATE  2           3      3/19 1           2      4/19 ...
Need Help
dax's avatar
dax
Icon for Community Support rankCommunity Support
7 years ago

Hi

I understand your logic, but if so, I think June(avg April May June) 4+4+*3+5/5= 3.25(16/5), the ID 6  should be 5, right? I will inform you as soon as I get it.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Tazmastablasta's avatar
Tazmastablasta
Icon for Helper I rankHelper I
7 years ago

Yes excaly, sorry for the typo. And thankyou so much for your time !