Your customer has a requirement where the rate to be used for converting the accrual units to the required units for payroll processing is based on the years of service of the worker. If the length of service is between 0 to 1 years, then the rate to be used for multiplying is 1.If the length of service is between 1 to 2 years, the rate to be used is 2 and so on. The customer has configured rate definitions for each of these rates individually.
You are asked to compose a fast formula that determines the length of service of theworker and dynamically uses the correct rate multiplier for rate calculation. The customer has created a rate definition by the name of “5YEAR RATE” which has the required rate multiplier value of “5” and a rate_id of “31000931415151”.
What value should your Global Plan Use Rate formula return for a worker who has 4.3 years of service to ensure that the right converted value is finally sent to payroll?