Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I´ve weekly amounts (e.g. Week 40: 15) and I want to aggregate these on a daily basis to a correct montly value. How can I achieve this in a elegant manner?
Thanks for yout ideas in advance...
Thorsten
I´ve found a solution by assigning 1/5 of the weekly amounts to each weekday (mo-fr)
starting by get the weekstart-date for the given week/year, I generate the necessary dates in a for...next loop...
here are the associated scriptcode
Hi Thorsten
the best way is to store your data at day level.
Then when you sum at weeks or months it will give you the right aggregated result because each day will be calculated in regard of according week and month
Best regards
chris
I´ve found a solution by assigning 1/5 of the weekly amounts to each weekday (mo-fr)
starting by get the weekstart-date for the given week/year, I generate the necessary dates in a for...next loop...
here are the associated scriptcode