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

New UX Filtering for Hierarchy sibling
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…
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.…