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 

Answers

  • Hi,
    you can use this formula to fetch the salary employee-wise.
    {'Module'.Salary[LOOKUP: 'System module'.Role] }
  • 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].