Notifications
Clear all
Topic starter
Your customer uses a look up table to calculate custom budgets, as shown in the attached screenshot. The budget is based on an employees country and status. In the template, the country is defined with field custom country and status is defined with field id customStatus .
What is the correct syntax to calculate merit?
- A . lookup(toNumber(,l2018_BudgetPool,,/ customCountry, customStatuS/merit)*curSalary
B. lookup(toNumber(,l2018_BudgetPool,,/ customCountry,customStatus,1)*curSalary
C. lookup(toNumber("2018_BudgetPool,,/ customCountry, customStatus, merit))*curSalary
D. lookup(toNumber("2018_BudgetPoor, customCountry,customStatus,1))*curSalary
Suggested Answer: D
Posted : 30/10/2022 7:25 am