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. 

Answers

  • 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.

    Snip20210607_10.png

     

    Tingting