Top Level Summing

tampara.dora · 2023-06-15T00:41:38+00:00

There was an error rendering this rich post.

Hello,

I have two modules A, B dimensioned by Region and Currency. The currency type has a top level of All currency due to that in module B the numbers are summing up x4 times based on module A(PFA screenshot). How do I get it to look at one currency at a time? I tried adding a look up and trying item(currency)= for each currency type. How

Screenshot 2023-06-14 at 5.41.15 PM.png

Accepted answers

All comments

Ashutosh

Hi,

As I understood, In region module u need a data as per currency selection. Please find below steps:

Create a module dimensioned by Currency and region.
The apply formula like Calculation = Data/Currency Rate (Currency conversion rate is coming from Module 1 which is dimensioned by Currency only ).

Hope that helps.

Thanks

Ashutosh

Quick Links

Can you help?

Unanswered questions

Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…