I have actual amounts (not shown here) by day, and need to display daily budget amounts as well. The problem is that my budget amounts are monthly totals. How would you go about this? In the script? In the expression?
This seems to be a good solution. What would be the expression to show the monthly total all dated Jan 1st to be spread about to each work day? Note my budget table has the 1st of each month with the budget totals...I need to divide the sum of those lines dated Jan 1st and times it by max current workdays of this month to get each days totals? Do you have this part of the expression?
Budget / Lookup('Divider','Period', Period,'Calender_div') as Daily_Budget
Load * Resident Calender)
Drop tables tmp_Budget, Calender, Calender_div;
If you want to add holidays or your company has some special dates, then you can give excel-file to your business users and they can define working days or production dates there and you can subtract those in script:
Mapping LOAD Date(A,'YYYY-MM-DD') as Date,
C as Open
Also with excel-file you can give different weight for days, if for example Monday has 50% of sales budgeted for certain week.