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

Compare/Sync new module that is working properly from Dev to PROD model _no amounts in PROD
I have created a Module "report" in DEV and it is working properly there, then I used Compare/Synce to bring into PROD, but for some reason it is not working properly in PROD. I have not amounts in PROD. I did check for any missing constants. Can anyone help with this issue or any advise?
AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
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…