I'm trying to divide quarterly data into 13 equal weeks of data. Dividing it by 13 wouldn't work since they need to be whole numbers.
Essentially the output would need to take the entire number and divide it by 13 and then equally allocate them into each week until the total is reached. The last week would have a lower number than the rest of the weeks.
If the total is less than 13, each week will have 1 unit until it reaches the total.
Hope I explained the issue properly. Any help with this would be greatly appreciated.
Thanks
Solved! Go to Solution.
Possible to share sample data ?
This is perfect.
Thank you.