What could be done to fix this behavior?

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?
A . Surround the curSalary with the toString function.
B . Surround the lookup function with the toNumber function.
C . Change the column to be of the Amount type.
D . Remove the extra parentheses.

Answer: B

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments