Forum Discussion
joshua1990
Post Prodigy
Post ProdigySplit Weekly Budget on Daily Budget
Hello everyone!
I would like to add a line to my bar chart to show the daily target for our sales.
The budget has the granularity of weeks. Now I need to divide this amount by the working days per week.
For this purpose, I added a WorkingDay (1 / 0) column in the calendar table.
Now, how would you calculate the daily budget?
1 Reply
- lbendlin
Super User
Have you tried dividing the weekly budget by the sum of your workingday column for the given week? I assume you flag holidays too?
