I’m creating a forecast for the sales in a month. It looks at what the average sales per day are for the month. Then multiples that by the number of days left for that day of the week per month. Like so
The problem is that the total’s aren’t working properly. Because instead of summing the Total Forecast, it’s multiplying the total of the weekly forecast by the number of days left.
I know normally you can get around this with SumX. But I’ve got two tables involved here. One the date table (where I can the number of days left in the month etc) and my fact table.