Lookup by roles and employees & country

143kishornaidu

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 

Capture_1_137820.PNG

Capture2_137820.PNG

Capture3_137820.PNG

Neeharika

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