Good morning,
First of all I want to apologize for my english but I requiered your help.
I come to you with a concern that I have been trying to solve for 1 week but I have not found any solution.
I need to visualize a table with the sales of the last 8 weeks, and this is already working but now I need to show the budget for each week and this is the part I need you help me.
The point is that the budget is loaded on the first day of each consolidated month. I tried to do it by taking the total sum for the month and dividing it into the days of the month then multiply it by the days of the week, but the problem is when the week combines days of 2 months.
I am using this formula for the last 8 weeks of sales (The sales are daily):
Sum({<Month=,Year=,[Weekname]=, [Year-Month]=,_WeekSerial={">=163>=171"}>} Sales)
What kind formula I should use for calculate the weekly budget if we only have the monthly budget in the system?
Thanks for any help