How best to create a variance module from a revenue module with a version dimension

Hi I need some help on this.

I have created a revenue module with a version dimension for actual and forecast.

The variance is a simple calculation of difference between the two.

The issue I have is since the actual and forecast revenues are sitting in dimensions rather than line items, how does once calculate the difference?

Would have been easy if they are separate line items but in the absence of that what formula (if any) would enable me to reference the actual and forecast data so that I can calculate the variance / difference?

Kind regards,

Clarence

Accepted answers

Vinay VaradarajM

Hi @ClarenceAndre,

There is a specific functionality in order to cater to this, which is "Compare".

You can find it in the menu as shown below:

Screenshot 2021-03-18 at 1.12.03 PM.png

Here is the link regarding its details:

https://help.anaplan.com/cdb30e97-cd8f-44e7-9172-6622102df880-Compare

Alternatively, you could create another line item without version as a dimension, and calculate the difference (Example: Value[SELECT: VERSIONS.Actual] - Value[SELECT: VERSIONS.Forecast], depending on how you want to represent.

Best Regards,

Vinay

All comments

Vinay VaradarajM

Hi @ClarenceAndre,

There is a specific functionality in order to cater to this, which is "Compare".

You can find it in the menu as shown below:

Screenshot 2021-03-18 at 1.12.03 PM.png

Here is the link regarding its details:

https://help.anaplan.com/cdb30e97-cd8f-44e7-9172-6622102df880-Compare

Best Regards,

Vinay

ClarenceAndre_*44012

Great thanks so much @Vinay VaradarajM let me check this out!

Kind regards,

Clarence

Quick Links

Can you help?

Unanswered questions

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.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385