About WanchiS

Thanks Einas! Your explanations are very helpful. I believe I have the correct lookup formula, which is very similar to the solution discussed in your 2 other posts: IF Employed? THEN 'EMP03 Employee Drivers by Role'.Medical Benefit [LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0 I added the top level to the "Role" list, and tried updating the formula again. I now get a different error message, "Data type mismatch: format other than LIST or DATE being referenced as a relation", which I am trying to resolve.  Would you have any tips or advice?  Thank you! ... View more

Thanks so much for your help!  I added the top level to the "Role" list, and tried updating the formula again, but got another error message, saying "Data type mismatch: format other than LIST or DATE being referenced as a relation".  I have a disconnect here because: 1) it does not make sense that a "Role" list to have "list" or "date" as the format, so I'm not sure why the error message is referring to them?   2) the formula I have constructed does not include the "Role" list in its reference (neither do the Target module (EMP02) or the Source module (EMP02) or the Mapping module (SYS08) referenced in the formula, so I am unsure how adding the top level to the "Role" list would correct the error?   IF Employed? THEN 'EMP03 Employee Drivers by Role'.Medical Benefit [LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0   Thank you so much!         ... View more