Setting Planning year based on date

swapnil_J
edited December 2022 in Modeling

Hi,

I have system module for time settings, and based on Today's date line item I'm trying to set Planning year which is current year + 1, when I'm selecting date between jan to dec 2022 it is showing me plan year as FY23 which is correct, but when I'm selecting date from JAN 2023 to Dec 2023 "Planning year" line item is becoming blank.

Today's date is date formatted and Planning year is year formatted line item.

swapnil_J_5-1670313349429.png

swapnil_J_3-1670313164161.png

Best Answer

  • StevenBeerthuizen
    edited December 2022 Answer ✓

    Your planning year is one year ahead, right....your current year is 2023 and you have no future years. So date 11/1/2023 -> Period(date) +1 = FY24....which is not in your model range. You should add future years if you want your formula to work:

     

    PERIOD - Anaplan Technical Documentation

    Constraints

    • Source must be date formatted.
    • Result must be time period formatted.
    • Result must fall within the time bounds of the model.

Comments