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:
I believe this is because I have not referenced role correctly in the SYS08 module:
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: