Hi,
Need help creating a formula that pick's up the moving average for a number within 6 business days.
Example) The amount for a line item over the past Weekdays were 1, 4, 6, 8, 9. I want to forecast this by finding the average of those days.
Thank you