FAST FORMULA to VALIDATE DATA FROM UDT AND RETURN A CALCULATED VALUE

Summary:

We have a requirement in the annual reward plan where the suggested solution is to create new UDT oracle table to hold salary midpoint for each (country, job code) - proposed ratio to market is then based on formula - 'proposed ratio to market' = proposed salary / mid point for proposed country job code (selected from UDT)

Content (please ensure you mask any confidential information):

We currently have the following columns on the worksheet:

Proposed Salary – enterable by managers
Proposed Job Code – sourced from the Promotions section of the detailed table
Proposed Ratio to Market – a custom numeric column