Level 1 Modeling Activity #5
Hello - I have been having similar issues with the formula updates to the Bonus%, Car Costs, Phone Costs and Medical Costs in the EMP02 Module - when I try to update the formula as below I receive the error message. I am seeing posts about removing the Role List and reimporting without the Parent Column and the reimporting into the EMP03 module - is this correct?
Error message - Invalid formula for 'EMP02 Employee Expenses'.Car Costs: Automatic sum of 'EMP03 Employee Drivers by Role'.Car Allowance over Role hierarchy is not possible as Role does not have a built-in top level
When I resolve this is this formula (below) correct?
IF Employed? THEN 'EMP03 Employee Drivers by Role'.Car Allowance[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0
Any assistance will be appreciated ..Thank you.