Level 1 model Building Activity 5

Evodekan

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

 

 

rob_marshall

@Evodekan 

 

Change it to list formatted as Role

 

Evodekan

Thank you 🙏 really helped 

JulianPeavy

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

TomOppers

Hi,

I'm stuck, why can't I adjust the formula?