Split Weekly Budget on Daily Budget

[joshua1990]

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?

[lbendlin]

Have you tried dividing the weekly budget by the sum of your workingday column for the given week? I assume you flag holidays too?