Lookup by roles and employees & country


Hi guys,


As you see in capture 1 we have the Role wise salary details , but i a not able to get these salaries by employee wise , please look capture 3 sys module is there anything i am missing to get releation


please help in that to get the employee wise details 


  • Hi,
    you can use this formula to fetch the salary employee-wise.
    {'Module'.Salary[LOOKUP: 'System module'.Role] }
  • Pooja

    In EMP007 module update formula in "ROle" line item "SYS001 EMp details.Role", as both target and source are having same EMP list it will map automatically.
    Then use this Role line item to lookup salary by role like EMP008.Total Salary[Lookup:Role].