Level 1 model Building Activity 5

edited January 2023 in Academy Discussions

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




Best Answer