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

Accepted answers

PrevContributor

Hi Adam,

please use "CURRENTPERIODEND()" function to refer to last actual period of calander which should ideally be the switchover period.

https://community.anaplan.com/anapedia/calculation-functions/currentperiodend?inheritRedirect=true

All comments

PrevContributor

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

Jaakko

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.

yelena_keselman

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)

DavidSmith

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

PaulWestonVA

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)

Community_Switchover_Manual_86679.jpg

Community_Switchover_Result_86679.jpg

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…