Need to change hourly merit amount to annual amount on compensation worksheet

Summary

Need to change hourly merit amount to annual amount on compensation worksheet

Content

I need to change the compensation merit increase amount for hourly employees to an annual amount.  I read Oracle document which describes this situation (Doc ID 2226097.1).  The plan frequency is "annual" and there isn't an appetite to have 2 plans - 1 for hourly and 1 for salaried.  

 

I am unable to create a dynamic column to convert the hourly merit increase into an annual merit %.  I tried adding extra columns  I am able to update the amounts when I enter the %, but am unable to update the % when I enter the annual amount.  See attached doc.  I have a dummy column that I can get the % into, but it doesn't go back to the original column.