Phone Cost for Sales Department


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. 


  • Hi

    If you refer to you employee system module, the Department & Role you are using in your lookup are text formatted. Instead of these two, you should use list formatted Department2 & Role2 in the lookup.

    On top of that, for Role2, you need to use FINDITEM formula to calculate the list item of the role first.