Level 1 Model Building Exam - Model Building Activity 5

HarshaR

Hello,

I cannot figure out the formula for Bonus and other line items for Level 1 Model Building Exam - Model Building Activity 5

 

I created the EMP03 Employee Drivers by Role module and added the department and role to it.

In activity 5, we have to change the module EMP02 Employee Expenses "Bonus" line item formula to fetch the bonus from EMP03 Employee Drivers by Role module. 

 

Your help on the formula is greatly appreciated.

 

Regards,

Harsha Rappan

 

HarshaR

Any Idea what the screen shot message means? I created a Role list and I added the Roles to SYS08 Employee Details module, now every employee in SYS08 Employee Details module has a role assigned to it.

 

As per the Level 1 Model Building Exam - Model Building Activity 5, we are to change the bonus formula of the 

EMP02 Employee Expenses module to get the bonus by department and role from the EMP03 Employee Drivers by Role module, this module has Bonus by department and role.

 

Attached is the question and here is my formula which is not working.

IF Employed? THEN Salary *  ‘EMP03 Employee Drivers by Role’.Bonus %[LOOKUP: ‘SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details’.Role] ELSE 0

 

Any help is greatly appreciated.

Screen_Shot_2021-12-14_at_10_127417.png

Screen_Shot_2021-12-14_at_8_127417.png