Custom Switchover

CommunityMember111277 · 2024-06-25T16:18:54+00:00

There was an error rendering this rich post.

CommunityMember111277

Hi,

I want to build a custom switchover for Fake version/List I created separately (Actual, Forecast, Rolling Forecast)

I created a custom switchover time period

2. Then I created a custom switchover period

3. Next, I have the module where I want to apply the formula, however its showing Circular references: values

Result expected

Thanks

Accepted answers

All comments

seymatas1

Anaplan's built-in time and versions support circular references, unlike fake time and versions. This is one reason why time and versions use more memory than regular lists.

For example, using PREVIOUS() formula, which is a circular reference, works with real time. But a similar formula structure does not work with fake time and throws "circular reference" error.

Similarly, PREVIOUSVERSION() formula works with native versions but not with fake versions.

Check out this How I Built it? video by @JaredDolich, it might give you some ideas on how to build a similar setup for fake versions.

CommunityMember111277

@seymatas1 I'm afraid this doesn't help with my requirement. Let me know if you have any solution to my query.

Preethi

@CommunityMember111277

I don’t think it’s possible to refer one list item value to another in same list. i.e copy Actuals to Rolling forecast in fake version list.

But you can try the below workaround:

In the Switchover time module, ideally the actuals month is always before the switchover starts, but your logic does vice versa. I have updated the logic accordingly. If not you can go ahead with your existing logic.

Then create an import module lets says, Switchover value without Fake Version. Include time dimension & 2-line items Actual & Forecast. Your actuals & Forecast values should be first imported in this module by mapping the Actual & Forecast line items respectively

Then create the Switchover value module with the dimensions – Time, Fake version, Value line item. Rewrite the logic for values by referring the Actual & Forecast value line items from above module. This will give you the desired result

Quick Links

Can you help?

Unanswered questions

Regarding WSA and NON WSA access
Hi, I have a model where the Channel changes based on the input date given by user, we have a Unique key based on the person and the Channel, suppose if the user gives his mail id, change the channel along with date in UX pages and after running the process approve the details of the previous record becomes un-editable and…
Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Not Able to Join the Level 1 Model Building Course
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?