Level 1 Modeling Activity #5

Options
RRawmplano
RRawmplano Member, ALL USERS Posts: 2 New Contributor
in Planning & Modeling

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.

 

 

Tagged:

Comments

  • egomez66
    egomez66 Member, ALL USERS, GroupMember, Certified Model Builder Posts: 5 Contributor

    Here are few things to check:
    1) You have created the Role List
    2) You imported the Role List
    3) You created a line item in the SYS08 as Role. This should be formatted as List and reference to the Role List
    4)You imported the SYS08 and it should update the line item Role and you should be able to see the roles filled for all the employees

    Now if you have done correctly above, then you should not have an error

  • RRawmplano
    RRawmplano Member, ALL USERS Posts: 2 New Contributor

    Thank you - changing the format to List Role seemed to have done it - appreciated..

Categories