Prorating Merit Budget?

Content

Our practice is to prorate new hires during the merit process. For example, if our merit budget is 3% and an employee was hired on July 1, that employee would be eligible for a 1.5% merit (prorated ~ 50%). How can I get my merit budget to include the proration in the calculation? I have added a column in the worksheets that reflect the employees proration factor (if they are not a new hire it shows 100%). In our old system, SuccessFactors, the proration was automatically taken into account when the system calculated each manager's budget. This is our first