Level 1 MB Exam- Activity 5



I'm working through the L1 MB exam and cannot figure out activity 5. 

The question asks you to update the formulas for the bonus and benefits lines, using a combination of data from the new role data and module SYS08. 

When I update with this formula: IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role'.Bonus % [LOOKUP: 'SYS08 Employee Details'.Role, LOOKUP: 'SYS08 Employee Details'.Department] ELSE 0

I receive this error message:

Screenshot 2020-11-24 at 13.56.50.png

I believe this is because I have not referenced role correctly in the SYS08 module:


Screenshot 2020-11-24 at 13.58.42.png

 However when I try and update this I have receive lots of different error messages: either they do not have a dimension in common, or if I add into the properties of the roles list to map to SYS08 then I receive this:


Screenshot 2020-11-24 at 13.55.35.png



Best Answer

  • Misbah
    Answer ✓


     Before you change the format remove the references and the formula and then try again. Once you remove the dependency, if any, then change the format from Text to List