What is the correct syntax for the calculated field?

Your customer uses a look-up table to calculate custom budgets as shown in the attached screenshot. The budget is based on an employee’s country and status. In the template, the country is defined with the field ID ‘custom Country’ and the status is defined with the field ID ‘custom Status’.

You need to create a custom field that contains the look-up value foe the promotion budget percent .

What is the correct syntax for the calculated field? Please choose the correct answer.
A . lookupC’2012_Custom_Budget_Poor" customCountry, customStatus,3)
B . lookup("2012_Custom_Budget_PooP customCountry, customStatus, 1)
C . lookup("2012_Custom_Budget_PooP customCountry, customStatus,promotion)
D . lookup("2012_Custom_Budget_PooP customCountry, customStatus)

View Answer

Answer: B