Level 1 Model Building Certification Exam Issues With Updating EMP02 Formulas
I am currently in the process of completing the Level 1 Model Building Certification Exam. I've gotten to a point where I've been asked to update the EMP02 formulas for Bonus %, Car costs, Phone costs, and Medical costs to reflect the new EMP03 module. I attempted #4 and failed both times, so now I'm on #5, which asks about Sales department phone costs in December 2020. The current formula I have in EMP02 is:
IF Employed? THEN 'EMP01 Employee Drivers'.Phone Allowance[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Country] ELSE 0
I've attempted the following formula:
IF Employed? THEN 'EMP03 Employee Drivers by Role'.Phone Allowance[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0
However, when I tried to submit this formula into the module, I got the following error:
Invalid formula for 'EMP02 Employee Expenses'.Phone costs: Automatic sum of 'EMP03 Employee Drivers by Role'.Phone Allowance over Roles hierarchy is not possible as Roles does not have a built-in top level
What exactly am I doing wrong here? Any help would be greatly appreciated.