Did anyone faced this issue, why Anaplan is not allowing me to fetch Items using FINDITEM formula?

I have a list named Custom Weeks, and applied FINDITEM formula to get items against 'Next Start Date Text', but except Week 40 FY22 and Week 49 FY22, FINDITEM is not fetching items from the said list. Need help.

Formula for 'Next Start Date Text' : TEXT(MONTH(Start Date + 7)) & "/" & TEXT(DAY(Start Date + 7)) & "/" & TEXT(YEAR(Start Date + 7))

Accepted answers

rob_marshall

@wolframarnab

A couple of questions:

is the above row axis the Custom Weeks?
If so, what is the code that it is using?
- if you don't have one, I highly suggest creating one where you can add 1 to it in order to get the next week.
Instead of breaking it down to the day, why not just add one to the code and do a finditem() on that.
How does the Custom week list differ from the regular Week list that comes with Anaplan or is the timescale for the model at the month level?

All comments

rob_marshall

@wolframarnab

A couple of questions:

is the above row axis the Custom Weeks?
If so, what is the code that it is using?
- if you don't have one, I highly suggest creating one where you can add 1 to it in order to get the next week.
Instead of breaking it down to the day, why not just add one to the code and do a finditem() on that.
How does the Custom week list differ from the regular Week list that comes with Anaplan or is the timescale for the model at the month level?

wolframarnab

@rob_marshall Thank You,

I got my answer, its the CODE which was mismatching.

Yes the row represents Custom Weeks, and its not a regular Anaplan Weeks list, its created but uploading a file.

The CODE of the Custom Weeks list is the Start Date, that's the reason, I was applying FINDITEM

Quick Links

Can you help?

Unanswered questions

Excel plugin issue with SSO
Has anyone gotten an error like this when you have SSO and you are trying to use the Excel plug in? We have some users that get the screen below but some don't. We have checked that all users have the same version of Excel. Weird part about the screen below is it actually says the connection was successful.
ERROR 16020 |-- Anaplan API: Invalid key path
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
Azure SQL Connection, database name with Hyphens in Data Orchestrator
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…