Level 1 model Building Activity 5

Evodekan
Occasional Contributor

Level 1 model Building Activity 5

Hi @JaredDolich  i Have stack with how to update the formulas for my Line Items in my Module EMP02 Employee Expenses. This is the formula i am using IF Employed? THEN Salary * 'EMP03 Employee Drivers'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0 

i have read other guidance saying that i have to change format of role in SYS08 Employee Details to List, E2 Employee# 

I get an error: Format of mapping used for lookup doesn't match any dimension of the source

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
rob_marshall
Moderator

@Evodekan 

 

Change it to list formatted as Role

 

2021-03-03_11-24-26.png

View solution in original post

3 REPLIES 3
rob_marshall
Moderator

@Evodekan 

 

Change it to list formatted as Role

 

2021-03-03_11-24-26.png

Evodekan
Occasional Contributor

Thank you 🙏 really helped 

JulianPeavy
New Contributor

Hi- I am having the same issue. Can you explain where you went to resolve this? Where can you change the details of SYS08?