Just a thought I want to share : can we create a department & Country line item in EMP02 Module itself and assign format as list E1 Department & G2 Country and make them available in EMP02 module itself and then refer them directly in formula from EMP02. Need your expert opinion on this & please suggest some other suggestion. Thanks & Regards
I still am not convinced that the formula didn't work - it has to work given the dimensions are correct.
To answer you question -You can do that but I wouldn't recommend you do that because it goes against DISCO (simply put best practices) Also you already have a connection between Employee, Department and Country, there is no need to have these line items in the module
Can you please post screenshots of your target module & formatting of your mappings. I place my bet on the mappings.
Re: Level 1 Model : Dimension of mapping used for lookup doesn't match any dimension of the result.
Thank you, my lookups are working now, brilliant, my data type was incorrect.
Apologies I am working on the next section REP04 Employee Expense Summary, I have set up the module, no worries, I am struggling with the formula, if I were calculating within excel I would opt for a SUMIF, which within Anaplan is a SUM function. I am trying to complete this using SYS08, is this the correct approach:
Do I need to create a sub model as per EMP03 and EMP02 to complete a SUMIF from SYS08 Data?