Formula help

I have 4 modules as shown in the screenshot. When I make an Override only for Brazil it is being carried into all of LATAM in Module 4.

In module 4, the revenue is pulling for all the countries when in-fact it should pull only for Brazil. How do I fix it?

Screen Shot 2022-10-13 at 11.47.28 AM.png

Accepted answers

All comments

JaredDolich

@tampara.dora

The key is to try not to get overwhelmed with the number of modules. That is why it is recommended you use system modules to create the relationships you need for a proper LOOKUP function. Make sure you target module has the dimensions (or lists) from it's corresponding system module to properly identify Brazil for you.

This guy does a great job explaining LOOKUP functions and how to properly use system modules.

https://www.youtube.com/watch?v=z1L5f6wawjc

Misbah

As @JaredDolich mentioned it is a typical case of LOOKUP.

Formula should look like

Module 2.Override * Input[LOOKUP: SYS Country Module.Region]

SYS Country Module should be dimensioned by Country List and should have a list formatted line item (Region List format) and update this line with PARENT(ITEM(Country))

Hope that helps

Misbah

Miz Logix

tampara.dora

thank you for the help.

Quick Links

Can you help?

Unanswered questions

RANKCUMULATE not working when adding additional dimensions to module
I have an issue where I am getting the expected result from RANKCUMULATE when using one dimension, but when I add an additional scenario dimension to the module, it doesn't calculate the way I'd expect. Here are some screenshots to explain the case: Module 1 - calculates cumulative total for list items in list "Age"…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…