I have a query that is similar to another topic raised a while back, but I can’t get it to work for me. Hopefully I haven’t just missed something obvious.
Original topic is here: Advanced Calculations for MTD and Budgets
I have set up a database that compares sales stream to a budget stream. I’m hoping to view MTD sales vs MTD budget. MTD sales works well, but I can only see the entire month’s budget figure in comparison.
The budget figure I’ve uploaded is for the entire month.
Is there a way to view a MTD budget figure? If the total monthly budget was $20,000, then half way through the month, I’d like to see a budget figure of $10,000.
It would be perfect if I could do it based on business days for the month, but I won’t be too fussy.
Please let me know if you need any other details.