Hi! I'm very new to alpha five and I'm not a programmer at all. The most I've done with formulas is creating basic formulas in excel so please be patient with me :o)
We are creating a web page that will house executive level performance and merit information. We are being asked to have a tab where we have current salary, merit percentage increase, merit dollar increase and New Salary. So for example:
Current Salary = 100,000
Merit % Increase = 10%
Merit $ Increase = 10,000
New Salary = 110,000
Here is the catch. I need to be able to let someone enter a $ amount OR a % and the other needs to automatically calculate. For example, if someone enters the 10,000 in the Merit $ increase field then the Merit % Increase should auto populate. If someone enters the 10% in the Merit % increase then the Merit $ Increase should auto populate. The New Salary can add the Current Salary and the Merit $ Increase amount.
What we have tried:
We enter a calculated field expression in the Merit % Increase to say something like - if(Merit$Increase > 0, Merit$Increase + CurrentSalary, 0) and in the Merit $ Increase field we have if(Merit%Increase > 0, ((Merit%Increase - CurrentSalary)/(CurrentSalary)), 0) except it creates a circular reference obviously and doesn't work.
We also tried using the onclick, onchange, onselect, etc. but we don't know java or xbasic to figure out what kind of wording to use so we keep getting errors. We checked the forums and the videos and still cannot figure this out.
Oh, we are connecting to a sql table that houses all our data.
If anyone can help us newbies we'd really appreciate it!!
Thank you so much!!!!
We are creating a web page that will house executive level performance and merit information. We are being asked to have a tab where we have current salary, merit percentage increase, merit dollar increase and New Salary. So for example:
Current Salary = 100,000
Merit % Increase = 10%
Merit $ Increase = 10,000
New Salary = 110,000
Here is the catch. I need to be able to let someone enter a $ amount OR a % and the other needs to automatically calculate. For example, if someone enters the 10,000 in the Merit $ increase field then the Merit % Increase should auto populate. If someone enters the 10% in the Merit % increase then the Merit $ Increase should auto populate. The New Salary can add the Current Salary and the Merit $ Increase amount.
What we have tried:
We enter a calculated field expression in the Merit % Increase to say something like - if(Merit$Increase > 0, Merit$Increase + CurrentSalary, 0) and in the Merit $ Increase field we have if(Merit%Increase > 0, ((Merit%Increase - CurrentSalary)/(CurrentSalary)), 0) except it creates a circular reference obviously and doesn't work.
We also tried using the onclick, onchange, onselect, etc. but we don't know java or xbasic to figure out what kind of wording to use so we keep getting errors. We checked the forums and the videos and still cannot figure this out.
Oh, we are connecting to a sql table that houses all our data.
If anyone can help us newbies we'd really appreciate it!!
Thank you so much!!!!
Comment