Date Input is outside the model time range
Hi,
I have a date formulas calculation to test whether the line item is falling within certain year, however cannot figure out what to do for the lines that fall outside of the model time period set up.
For example, I have a contract that starts from 2020 to 2025 and the model is set up as 2 past year and 2 future year (so the model only captures up to 2022 currently). When I do the formula, because 2025 is outside my model time set up, it will always give false even though technically time now is less than 2025. Is there a way to get this right?
Can anyone help?
Thanks!
Best Answer
-
If you create a time range that includes 2025 then that should appear in your model. Link here for more info on time ranges: https://help.anaplan.com/2d10945f-3e50-4310-beee-5a332269ce0e-Time-Ranges
By doing this, you are increasing the superset, and 2025 (and 2023 and 2024) will appear in your formula, and it will not add size (unless you dimensionalize something by the new time range).
Information of Time period Selection, and the superset here: https://help.anaplan.com/3d477887-b264-4105-b3b7-5fcad2af1255-Time-Period-Selection
Jason
2
