FINDITEM formula



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


Thanks & Regards



  • Yep


    FINDITEM(Time, text)



  • 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


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