Level 1 Model Building Exam-Model Building Activity 5

neg177
neg177
in Academy Discussions

Having trouble with how to update the formulas for my Line Items in my Module EMP02 Employee Expenses. I need to update the formulas so that they reference my EMP03 Employee Drivers Module. For example how would I up date the Bonus% Line formula (IF Employed? THEN Salary * 'EMP01 Employee Drivers'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Country] ELSE 0) if I want it to reference EMP03 Employee Drivers by Role Module? Attached is a pic of the problem I'm trying to solve. anaplan questions..PNG

 

Thank you 

Comments

  • ashish.banka
    ashish.banka

    @neg177 You are so close. While updating the formula from EMP01 module to EMP03 module, you need to look for a mapping between EMP03 module role with SYS08 Employee Details module.

     

    Hope this helps

     

    Ashish

Categories