FINDITEM formula

Hi

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

 

Thanks & Regards

Keerthi

Answers

  • Yep

     

    FINDITEM(Time, text)

     

    David

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

     

     

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

    David

  • 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.

  • 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