Allocate quarterly data into weekly buckets

[creddy]

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

[ponraj]

Possible to share sample data ?

[danrh · Accepted solution]

Something like this?

This divides by 13 and rounds down to next next whole number, generates 13 records and adds this new weekly value to each of those, then divides up the remainder starting with week 1.

Hope it helps!

[creddy]

This is perfect.

Thank you.