Occasional Contributor

FINDITEM formula

Hi

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

 

Thanks & Regards

Keerthi

5 REPLIES 5
Community Boss

Re: FINDITEM formula

Yep

 

FINDITEM(Time, text)

 

David

Occasional Contributor

Re: FINDITEM formula

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

 

 

Community Boss

Re: FINDITEM formula

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

David

Occasional Contributor

Re: FINDITEM formula

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.

Highlighted
Super Contributor

Re: FINDITEM formula

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.pngScreen Shot 2019-07-05 at 3.30.22 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