Problem in building a dynamic Version to Version Variance Calculation

Monpero · 2024-05-16T12:30:09+00:00

There was an error rendering this rich post.

Hi All,

I have a request by a customer to have version to version variance analysis done where, when a version is selected from a drop down for comparison the version name selected appears on the column header. And not version 1 or version 2

NB: Am not using a native version. The version used for the drop down is a custom version with many versions.
e.g - 1+11 FY24, 2+10FY24, 3+9FY24, 4+8 FY24

Please guys is there a work around to achieving this build?

Any suggestion will be really helpful.

Thanks.

Accepted answers

Ashutosh

Yes, Map to forecast variance list to version list to get data at version list. Please find updated step.

All comments

Ashutosh

Are u using custom versions or Native Version?

Monpero

Hi @Ashutosh I am using a custom version not a native version.

Ashutosh

Assuming you are using Custom Version . Please find the below steps:

Create a another list which have version names and also add one another item Variance . Use that list for selection.

2. Create a mapping module between the version variance list and custom version.

3. Create a another module using the forecast variance list and other versions excluding custom version list and create below line items as shared in screenshot :

4. Create a Final Filter module by using version variance list and line item 'Filter':

Formula for filter line item :

And apply that filter in step 3 module and show line item name 'Final Data'.

Hope that will solve your issue.

Thanks

Ashutosh

Monpero

Thank you very much @Ashutosh for taking your time to create this awesome workaround. I'm not so clear with the step 2 part.

2. Create a mapping module between the version variance list and custom version.

Could you please explain clearly on this one. What I gathered is that with this I will have 3 different custom version. My original custom version list, b, the mapping version and c, the Forecast version.

Is that what you mean?.

Thanks once again for your time.

Ashutosh

Yes, Map to forecast variance list to version list to get data at version list. Please find updated step.

Monpero

Thank you @Ashutosh for the work around.

Quick Links

Can you help?

Unanswered questions

Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
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.…