@WanchiS wrote: 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 Official Site 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! I faced the same issue, still facing that, no solution yet.
... View more