MONTH Formula providing unexpected results with Fiscal Year beginning in February.

[Jivey11]

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?

[rob_marshall · Accepted solution]

@Jivey11 ,

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,

Rob