Phone Cost for Sales Department

Options
egmorale
egmorale Member, ALL USERS, GroupMember Posts: 4 New Contributor

I have been trying to figure out how to solve this issue that keeps popping up when I enter this formula:

 

IF Employed? THEN 'EMP03 Employee Drivers By Role'.Phone Allowance[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0

 

I know it is something with the Roles list and the hierarchy, but I don't really know how to go about it.