Variance Analysis between versions without using select

Hi,

I am trying to create a variance Analysis for users so they can compare price & volume between to Anaplan versions (i.e Budget & Forecast, Budget & Actuals).

This idea is for user to select Version 1 and Version 2 to decide which versions they want to compare. Similar to:

Select V1 : XX (i.e Budget)

Select V2: YY (i.e forecast)

Price Variance Analysis: P(YY) - P(XX)

My calculation module (no versions) will take the data in different modules with versions. Is there any way to compare my different elements between versions without using SELECT: and refering directly the two chosen versions ?

Thanks for you help,

Accepted answers

All comments

ravi

We achieve this using a custom versions list instead of the standard versions list. It allows us to use LOOKUP and show the data based on the versions user selects. Please let me know if you want more details.

sweemaels

Thanks for your answer !

Unfortunately we've been building the entire model on anaplan versions. It is thus not an option for us to switch to custom versions..

CommunityMember96369

Hello! There some sophicticated and effective techniques on variance analysis with select (like this: model is built on anaplan versions, for variance analysis anaplan versions are converted into virtual versions using select function).

Below are two options to build variance analysis without select function:

- Option 1: Use specific anaplan versions for variance analysis (see screenshot with example)

- Option 2: Use compare functionality (see screenshot with example)

BR,

Igor

Variance_analysis_wo_select_option_with_compare_34931.png

Variance_analysis_wo_select_option_with_new_versions_34931.png

nathan_rudman

There is no way to bring native version onto a list or a line item subset without doing a select.

However, having a centralized module where you use line items to recreate versions (with select) and transform these line items into a line item subset isn't too much maintenance (unless you create a lot of versions of course. You can then use a formatted line item drop down displayed on a dashboard to allow your users to choose what they want to see.

You have examples of various ways to do a dynamic variance analysis in this app:

https://community.anaplan.com/t5/Finance/Planning-Budgeting-and-Forecasting-for-Saas/ba-p/28006

Hi Ravi,

Would you be able to provide more detail around how to achieve this in practice?

Thanks

Quick Links

Can you help?

Unanswered questions

Update email id
Can anyone please explain how to update my registered email ID jn Anaplan.
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
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.…