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

Re: Level 1 model Building Activity 5

@Evodekan 

 

Change it to list formatted as Role

 

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

View solution in original post

2 REPLIES 2
rob_marshall
Moderator

Re: Level 1 model Building Activity 5

@Evodekan 

 

Change it to list formatted as Role

 

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

View solution in original post

Evodekan
Occasional Contributor

Re: Level 1 model Building Activity 5

Thank you 🙏 really helped