Forum Discussion
Moving average excluding weekends and holidays
Community ChampionAnonymous
Hang on... the table that you are showing, the one with the data, does it include weekends, holidays, company holidays as well? If so, what is the value of [Daily Count] on those days? Is it a blank(), a valid value that you just want to ignore?
AlB The table that I have listed up there only includes working days (everything but weekends and corporate holidays).
- AlB
Anonymous
I'm getting a bit confused, sorry.
Is that then the format of the table you'll be working with? It only has entries for weekdays that are not corporate holidays?
Or is that just the case with the table that you listed?
Not a problem, thank you for the help so far!
So the sales table that I listed in the first example, with the screenshot, does not include weekends or holidays. Essentially, I'm trying to find a way to do a moving average from a specific date and the four prior entries for a particular group. Hopefully this helps and clarifies. Let me know if you have any other questions.
- AlB
Anonymous
Ok but what I am asking about is the real table that you will use in your calculations.Let's forget about the example shown.
The "real" table has entries on weekends and holidays?