Forum Discussion
amaddala
Helper I
Helper IMoving average with custom calendar
I need help calculating moving average of last 4 fiscal weeks in my data. We cannot use datesinperiod as I need to use "Week" in my steps. I have fiscalweek number ( for ex: 31, 32, 33 etc ) Please...
Hi amaddala ,
Could you please tell me what went wrong? Could you share some screenshots around the issue please? This is not helping much.
Add error screenshot as well which you are facing.
I tested it again with new data, and there were no errors.
You said that you want to calculate the moving average of the previous four weeks, but the formula you gave is the moving average of the previous six weeks.
Maybe I'm not getting what actually you are trying to do.
Best Regards,
Yuna
amaddalaHelper I
Helper IThank you, I have just used 6 weeks instead of 4 with the same logic you shared as my business requirement changed. Below is the screenshot for what I am seeing with my code vs yours.