Trying to understand what is wrong with this formula and why it doesn't give me 2019-2022. Instead, I only get 3 years, 2020-2022. If I change the formula to Prior Year -2 I get 2021-2022. Would appreciate any ideas.
@lkrylov
Make sure your "Prior Year" format matches what you're comparing to. In your case you want them to be PERIODS (months).
See if that helps. You can also try converting to the year (period) or Year (Number) since that's what your testing for anyway. you don't really need to use months from what I can tell. Depends on your use case.
Thank you for the incredibly quick response Jared!
I tested some other options and found that this formula works.
PERIOD(START()) <= Current Year + 1
Thanks for the tip on the Months. I realized that I had to also change the Summary to be Formula, Time: Any
Hello everyone, We are trying to use Anaplan Connect in order to push data from a dwh to Anaplan Data Hub. To do so, we need an authentication by token. We can't make it work, we receive the following error: ERROR 16020 |-- Anaplan API: Invalid key path Any suggestions? Thank you all in advance for the help! Michele
I am attempting to connect to an azure SQL database vis at the MSSQL connector in data orchestrator but am having issues and I believe it is due to hyphens in database name (which is a fairly standard naming convention I will note!) Example below (fake credentials) - has anyone else encountered similar and is there a way…
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
