You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to populate increment value from a UDT to the Worksheet Display ?

Received Response
19
Views
2
Comments
edited May 31, 2021 11:13AM in Compensation 2 comments

Content

Our client has a requirement where they do not wish to change the Dynamic values every year and would want to just load the values to a UDT and we should populate the increment percentage based on that.

So we have 3 columns

 

Performance Ratings  Grade Increment
5 M1 10
4 M1 8
4 M2 9

Is there a way to pull the values of UDT through a fast formula? My developer was telling that it only works where there is only one criteria,eg Grade but when we try to pull a combination of Performance Ratings & Grade,its unable to pull the increment percentages.

Please let us know if we have a solution for this as there is a possibility that we might have to give 3 keys too based on client requirements

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!