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

Highlighted
New Contributor

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

Jivey11_0-1597085505085.png

Jivey11_1-1597085654540.png

Jivey11_3-1597085726937.png

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?

 

 

 

1 REPLY 1
Highlighted
Master Anaplanner/Community Boss

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

@Jivey11 ,

 

Great question, it is because you have some of the days in Feb rolling up into January of the previous year

 

2020-08-10_14-30-16.png

 

If you don't want that, create a line item with the formula yeartodate(1)

 

2020-08-10_14-33-50.png

 

Hope this helps,

 

Rob