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

RetrieveTIMESUM using ANY
Hi everyone, I was trying to Retrieve a Line Item (Boolean) using TIMESUM as formula to another module by using ANY. This Boolean LI has A,B,C as dimensions. My target module has only A as dimension. In order to use a reference module for mapping, does this reference module had to have A,B and C as dimension or just A…
Regarding to gain employment with a customer or partner of Anaplan
I have complated my Anaplan Level 2 Certification. Can anybody assist me to get a employment opportunity to get access for Level 3.
Field Selection (Not give the option to select Top level)
I have a list call lease ID that has a top level called All Lease ID. I do not want the top level to be seen in my selection. What can i do ?