I've found some code on this discussion board that I'm trying to tweak to solve my problem, but it's not quite working right. I need to calculate MTD (month to date). This is the code I have:
In my date, the MaxYr = 2011 and the MaxMonNum = 7. I don't want it to change based on month/year selections on other report tabs - it should always just reflect the numbers of the current month (based on the month of the MaxDate of the report).
The formula is returning just the total Sales number, based on the reports Year/Month selections - it appears to not recognize the max year/max month combination. Ultimately I want to make a current month projectiong, so I'd be taking the MTD number, dividing by the number of days that have occurred in the month, and divide by the total number of days in that calendar month. If you have any expressions for this as well, that'd help, as I have a feeling that once I resolve this MTD expression I might need more help.
Any suggestions to solve would be greatly appreciated!
