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.
I looked at the info you gave and tried inputting "All Roles" as the top level. However, there is already a parent item in the list called All Roles. Is there a better top level, such as Total Company to use for this roles list?
I am in the middle of the exam and am having this exact issue. Did you ever sort this out?
Formula updates won't work (same error message you got), and I cannot add the top level item "All Roles" for the same reason you couldn't - "'All Roles' is not valid for the name of the top level item of Roles. 'All Roles' clashes with the name of an existing List Member."