October 3, 2016 at 4:15 am
I need to pro-rata a monthly budget so that a greater proportion is allocated to beginning of month.
They want it to be:
working days 1-5 = 40% of total budget
6-10 = 30%
10-15 = 20%
15+ = 10%
There is a table currently in the system called x_workdates:
SeqnoDateWeekdayWorkday
2071 1/09/201651
20722/09/201661
20733/09/201670
20744/09/201610
20755/09/201621
Any ideas on the best way to go about this would be great.
Thanks
October 3, 2016 at 5:43 am
Kn1807 (10/3/2016)
I need to pro-rata a monthly budget so that a greater proportion is allocated to beginning of month.They want it to be:
working days 1-5 = 40% of total budget
6-10 = 30%
10-15 = 20%
15+ = 10%
There is a table currently in the system called x_workdates:
SeqnoDateWeekdayWorkday
2071 1/09/201651
20722/09/201661
20733/09/201670
20744/09/201610
20755/09/201621
Any ideas on the best way to go about this would be great.
Thanks
Sounds simple enough. What do you want your output to look like? If you would like help in constructing a working query, please follow the first link in my signature, which will guide you on the information which you need to provide.
October 4, 2016 at 8:52 pm
Thanks, yes I thought it looked easy enough to start, but then i came up with more questions than answers and soon I was going around in circles and got absolutely nowhere. What I'm wondering is whether I should keep trying to write the query based on the table i have, or add a calculated column to the workdays table somehow that says its week no 1 etc. But that then got me in circles again. I'll try to get at least something working. Maybe I should be posting to SSRS that I just found. This was my first post.
Thanks 🙂
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply