Referencing Switchover Period

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

Best Answer

Answers

  • Hi Ramu,

    what if you have multiple versions, each with different switchover dates? In this case, what would be the way to reference the switchover period of each version?

    Kind regards,
    Marcel
  • Hi,

     

    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.

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

     

  • If you are unable to access 'Total of All periods' then amend the formula slightly as per the screenshot Community_Switchover_Manual to get a reasonable result (Community_Switchover_Result)