MONTH Formula providing unexpected results with Fiscal Year beginning in February.
In the screenshots provided above you will notice the Month Value line item have a different value for the months in FY19 than in FY18 ***Formula is MONTH(ITEM(Time)). In FY19 you will also see the value of 9 be returned for September and October and 12 returned for December and January. Can someone help me better understand the reason for the results?
Great question, it is because you have some of the days in Feb rolling up into January of the previous year
If you don't want that, create a line item with the formula yeartodate(1)
Hope this helps,