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?
Answers
-
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.
4 -
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
1 -
thank you for the help.
0
