Level 1 Exam Activity 4 & 5

Options
Jmontoya299
Jmontoya299 Member, ALL USERS, GroupMember, Community Member, Certified Model Builder Posts: 1 New Contributor
in Planning & Modeling

Hi all, 

 

I've been stuck on both these questions for the past 3 hours and now I'm on question 6 and it seems to build on these two previous questions. I've searched previous posts but and I've followed those steps but the numbers are still incorrect. I'm not too sure what to try any more. 

 

I have made the SYS008 module to have the E3 Role list as the format. (Getting here was a mess as well, since I had to modify the Role.csv and delete the parent column, as suggested from another post). I've added All Roles as the Top Level Item in the Configure tab of the E3 Role list. 

 

The formula I'm using for EMP002 is IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role'.Bonus %[LOOKUP: 'SYSO8 Employee Details'.Department, LOOKUP: 'SYSO8 Employee Details'.Role] ELSE 0. It seems to pull numbers now, but they are extremely high numbers even for just one individual. 

 

I've attached some screenshots for clarity. 

 

I'm really not too sure what the issue is anymore. Any recommendations or help would be appreciated. 

 

Thanks, 

Jeison M. 

 

 

 

Tagged:

Categories