Setting Planning year based on date
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.
Best 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.
0
Answers
-
-
Hi @StevenBeerthuizen, The system module dont have time as a dimension, Also I tried same by selecting Previous dates between Jan 2021 to dec 2022 and it is working fine, but it is not working when I'm selecting dates from Jan 2023 to Dec 2023.
I have tried this by updating the model calendar as well.
0 -
Thank @StevenBeerthuizen, got the result after updating time range.
0 -
No problem @swapnil_J
Since your issue is solved, maybe you can mark this topic as solved.
Kr,
Steven
0