Formula help

tampara.dora
edited November 2022 in Modeling

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

Comments

  • JaredDolich
    edited November 2022

    @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
    edited November 2022

    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
    edited November 2022

    thank you for the help.