Lookup by roles and employees & country

143kishornaidu
143kishornaidu
in Modeling

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 

Tagged:

Answers

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

Categories