FINDITEM formula

keerthi_malathkar

Can we use time rang for finding time period while using finditem function.

Thanks & Regards

Keerthi

Accepted answers

All comments

DavidSmith

Yep

FINDITEM(Time, text)

David

keerthi_malathkar

yes I applied that formula but it is referring time of model calendar not of time rang which I had created.

DavidSmith

Should work exactly the same, should have added, the text format needs to be MMM YY

David

keerthi_malathkar

Hi David

Please check the attached jpg files. As you answered regarding format, I did so but the Time list in the formula is taking the time period of model calendar not of time period which I created in time range.

query1_48255.jpg

query2_48255.jpg

LipChean_Soh

Hi,

You can try the following:

Screen Shot 2019-07-05 at 3.30.03 PM.png

Assuming you have 3 Time Ranges shown above.

Screen Shot 2019-07-05 at 3.30.09 PM.png

Note the 'Time Scale' and 'Time Range' in the 'FY20 - FY21' line item.

Please build according to DISCO, and build 'FY20 - FY21' in a separate System module.

Thanks,

LipChean

Quick Links

Can you help?

Unanswered questions

Hi Team , I am unable to login to the Anaplan portal using my credential.
Can someone help me i am unable to login anaplan portal using my credentials
Finding History for List Item Creation and changes
Dear Hive Mind, Do we have a way to get the history of a particular List Item, from its creation into a model up until its removal ? I am trying to chase when / how an item has been added into a model and how / when it would have been deleted and then recreated with the same code. Is there a pattern (manual or API) to get…
Action fails via cloudworks but works manually
I have an action in a process which is getting failed since 2 days when run via CloudWorks with below error . No issues when run manually . Same error occurs when run manually but as a warning "Import complete but with failures" This action is running since almost a year without any issue . No change has been made to…