Forum Discussion
Helper ICustom Time Intelligence - Current Day in Month vs. Prior Months
Yeah, sort of. Keep in mind that this will be very wobbly at the beginning of the month. Let's say
July - starts on a Friday
August - starts on a Monday
September - starts on a Thursday
Let's assume you only have transactions Monday through Friday.
First 6 days:
July: 4 working days
Aug: 5 working days
Sept: 4 working days
I think you can see where this is going. It becomes less of a problem the older a month gets.
Helper IHow about days in month vs. same days in month vs. prior months?
ie. Sep = 6 days, vs. Aug = first 6 days, vs. Jul = first 6 days.....
Super UserYeah, sort of. Keep in mind that this will be very wobbly at the beginning of the month. Let's say
July - starts on a Friday
August - starts on a Monday
September - starts on a Thursday
Let's assume you only have transactions Monday through Friday.
First 6 days:
July: 4 working days
Aug: 5 working days
Sept: 4 working days
I think you can see where this is going. It becomes less of a problem the older a month gets.
- Dlahey
I am comfortable with this, we only have refreshed sales data on a weekly basis therefore the minimum days would always be 4 or 5 working days with holidays factored in. However, this still gives a good indication to our company. thanks