Whats the difference between 12 mtd , 12 mtd rolling and ytd calculation
+8
A:
12 mtd goes back 12 months, whereas a ytd is from the first day of the current year (calendar, fiscal, whatever) to the current day.
Hank Gay
2009-03-17 13:28:20
What about 12 mtd rolloing ?
Tommy
2009-03-17 13:48:44
To my mind, the "to-date" portion of mtd makes it rolling by definition.
Hank Gay
2009-03-17 13:54:14
I agree, not sure what the difference might be between 12mtd and 12mtd rolling. One possibility is that a rolling average is what's being asked for in the latter case.
Rog
2009-03-17 23:23:08
+1
A:
Example:
Today=20090318
REPORT TYPE - REPORT PERIOD
12MTD report - 20080401 to 20090318
YTD report - 20090101 to 20090318
AFHood
2009-03-18 12:18:00