Calendar Setup in anaplan

Options
MadhabikaM
MadhabikaM Member, ALL USERS, Certified Model Builder Posts: 5 Frequent Contributor
in Planning & Modeling

Hi Team,

 

I am having trouble in Calendar Setup, I need a 4-5-4 Setup and my Current Fiscal Year is (FY21 :26 Sep 2020 - 24 Sep 2021).

This Setup works fine for FY21 & FY23 as it's 52 Weeks but for FY22 as its a 53 Weeks calendar,

Q4 of FY22 is 4-5-5 instead of 4-5-4 as regular setup, Is there a way to account for this.

attached screenshot below for model setup currently.

 

Capture.PNG

Tagged:

Comments

  • MadhabikaM
    MadhabikaM Member, ALL USERS, Certified Model Builder Posts: 5 Frequent Contributor
    I want by Q4 of FY22 to follow 4-5-4 calendar, i,e 26 Aug FY22 to be Month end date and 27 Aug FY22 date onwards should fall under month Sept FY22.
    I have a line item date format and second line item that derives forecast month from date assigned.
    So any date till 26 Aug derives a month as Aug 22 which is fine but as FY22 is 53 weeks calendar any date which is 27 AugFY22 through 2 Sept FY22 derives forecast month as Aug 22 which I expect to be Sept 22.

    Attaching a screenshot if that helps.

Categories