Is there any way in a formula to reference the Switchover period for a version? The module is pulling in data from a list across the time periods but if the cell is for a time period prior to the Switchover period, I want it to show zero, else pull data from the list. Thanks
Solved! Go to Solution.
I agree that formula for referencing the switchover period would be a great addition. I once created a time property module where I managed to derive a month formatted line item with switchover period for each version. I started with creating a line item with formula for actual version only and then in another line item with switchover on I could use previous() and next() functions to find out the switchover period. However, finally we decided to abandon that solution because it became overly complicated for that purpose. We decided to have a module with manual maintenance of switchover period for each version. That module included only "Switchover period" line item and versions. It was quite handy but still not as good as formula for it would be.
The switchover date can be extracted with the simple formula “IF ISACTUALVERSION() THEN START() ELSE BLANK” and a summary type “first non blank” on a line item with a time scale. Then link this item with another one without time scale and [select:time.all periods].
There is a example of this in the Time Filter app in the App hub, in the module Switchover detection
1) Create a module by time, by versions
2) Create line item, format to time periods
3) Set summary method to 'first none blank'
4) Formula: if isactualversion() then blank else item(time)