Actual vs Last Year

I would like to store last year actual value in version. So my version willl have Actual, Last Year and Act vs LY Variance.

Can I achive it using formula in Version setting?

Thanks and regards,

Maung Maung

Accepted answers

All comments

LipChean_Soh

Hi Maung Maung,

Using a Version to come up with a variance, though possible, will take up A LOT of workspace.

I would prefer to understand more about your business requirement, before coming up with a suggestion; but at the mean time, below is a suggestion using line item formula and formula scope.

The results are:

Thanks,

LipChean

mmhtwe

Hi Lip Chean,

Thanks for the suggestion. I want to achieve account and version as cross dimension. Otherwise, I will have to another line item for each account. The screen shot is the sample.

Thanks and regards,

Maung Maung

Version_Cross_Dimension_30020.jpg

mmhtwe

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.…