How to fetech Element Entry value in worksheet to display

Content

Hi,

 

I am trying to create a compensation worksheet for annual salary review, employees who has individual comp plan in the form of spot bonus should display in  the worksheet. To achieve this in the worksheet display  - User Defined columns , I took numeric column and in the properties I mapped element name which is mapped to ICP plan setup used for spot bonus value to hold.

I am expecting doing this would help in populate the spot award field in the worksheet; which is available in the element entry page  of an employee, although its not working.

Looking for any guidance or inputs.