You have configured a worksheet for a client that uses the following formula in a...

SAP C_THR86_2411 Question Answer

You have configured a worksheet for a client that uses the following formula in a custom column of type Money: (curSalary lookup("budget_table",customCountry,1))/100.

The lookup table "budget_table" is configured with one input one output. There are three rows in the table:

•USA = 5

•GBR = 3

•*=2

When the worksheet loads, the column displays correctly, but when a merit value is changed, it switches to N/A for the employee. What could be done to fix this behavior?

Surround the curSalary with the toString function.

Surround the lookup function with the toNumber function.

Change the column to be of the Amount type.

Remove the extra parentheses.