Hi, I have searched through many forum topics and videos, but I can’t seem to get the logic required for this. I’m doing some Variance analysis on current year Sales, forecast and budget, plus budget for next year. Budgets and Forecasts are based on sales last year * Growth Rate. The rows return the right numbers, but the total is incorrect. Financial year is Oct to Sep which is working ok.
When I compare forecast to last year again it’s returning the right rows, but wrong total. Same when I’m calculating cumulative.
Test model below. I’ve removed sensitive data, but structure is basically the same as full model.
Test Model.zip (1.4 MB)
Any help greatly appreciated.