Time Formatted Line Item - Custom Time Range

Question

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 · Accepted Answer

@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