Formula help

tampara.dora

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? 

 

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.