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?
Submit