Dual Updates with Two Dynamic Columns

Summary

I need to base my percentage column off my amount column, and vice versa.

Content

Hi,

I have an issue with Dynamic Columns overriding themselves, how can I overcome this issue?

I have four columns;

• Current Salary
• Percentage Increase
• Amount Increase
• New Salary

If I enter a Percentage Increase, I want it to update the;

1. Update Amount Increase: [Current Salary] * ([Percentage Increase] / 100)
2. Update New Salary: [Current Salary] * (([Percentage Increase] / 100)+1)

If I enter an Amount Increase, I want it to update the;

1. Update A Percentage Increase: [Amount Increase]/[Current Salary]
2. Update New Salary: [Current Salary] + [Amount Increase]

Currently what happens if I enter an amount, it will calculate the new salary, then blank out the amount and the percentage columns. Same thing happens when entering a percentage. How can I make one happen if the other occurs before?.