Formula

Hello,

Quick question: How can I calculate the Volume between FY17 and F21 in the other module? For example, the difference between two years.
Note: Just Volume is a line item.

Please see the attached.

Thanks,

Mark

Accepted answers

All comments

ShubhamCh

Hi @Markcol

I see there are 4 dimensions (including time) in the current module. Understanding as much as possible from your description and the image, I assume you want to select one value from each dimension and then you want to calculate the difference between the volume.

Here is my idea:-

Create one dimensionless module, add two line items for each dimension
- Dimension 1.1, Dimension 1.2, formatted by Dimension 1
- Dimension 2.1, Dimension 2.2, formatted by Dimension 2
- Dimension 3.1, Dimension 3.2, formatted by Dimension 3
- Period 1, Period 2, formatted by period (Year)
- Volume 1, Volume 2, Number formatted. To store the values corresponding to other dimension
- Difference, number formatted. Formula:- Volume 1 - Volume 2
Formula of Volume line items :- "The Source Volume line item"[Lookup: Dimension1.1, Lookup:Dimension 2.1, Lookup: Dimension 3.1, Lookup: Period 1]. Reference the other line items in Volume 2's formula.
You'll have to manually select the values from list drop downs.

I hope it solves your problem.

Thanks!

-Shubham

Markcol

Hi @ShubhamCh,

Thank you very much for your detailed solution. I’ll try the solution.

All the best,

Mark

Quick Links

Can you help?

Unanswered questions

one or multiple models
Does anyone have any documentation on the trade-offs of having 1 model for all components of planning (service revenue, product revenue, labour planning), vs multiple models 1 for each and a consolidation model to tie it all together?
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
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.…