Time Formatted Line Item - Custom Time Range

MarkTurkenburg_*8288

Hi,

 

Is there a way to use Custom Time Ranges when creating a Time Period formatted Line Item?

 

I wish to display only a certain number of periods as a selection option but currently all periods are the default

 

Many thanks

 

Mark

DavidSmith

@MarkTurkenburg 

Unfortunately not at this time by default.  The list of time periods is what is called the "superset" of all time periods available from the earliest date of time ranges and the model calendar to the last date of any time range or model calendar

It is something that has been raised previously, but check in the idea exchange, and if it is not there, add it; then it will get into the system

However, there is a workaround:

Create a dummy time list that mirrors the time range and then create a line item, formatted as time with the formula FINDITEM(Time, Name(time period choice)) assuming the pick list was called time period choice, formatted as the dummy time list

As a tip, I would make the dummy list format the same is the display for the main timescale,; it makes the FINDITEM simple without any manipulation

I hope this helps

David