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

justinivey
justinivey
in Modeling

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?

 

 

 

Tagged:

Best Answer

  • rob_marshall
    rob_marshall
    Answer ✓

    @justinivey ,

     

    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

Categories