Calculating InputBox

[JasonMilwaukee2]

Hi, I have a Sharepoint list that I have modifed the form for.  The main fields that I am using are:

Current Salary

Percentage Increase

Future Salary

I want to be able to set the future salary = Current Salary * Percentage increase.  Also, update the percentage increase based on dividing future salary by current salary.

I currently have an onchange function  on percentage increase and future state, by using variable test1 and test2.  This works great on the initial save/create.  Percent increase and future salary both have their default values set to the variables.  The issue I have is when I open an item from the Sharepoint List, it is referencing the 2 variables in the default and not the values from sharepoint.  How can I get the real-time calculations and the default value to work (when a user wants to edit this)?

Set(test1,(((DataCardValue16.Text / DataCardValue14.Text)-1)*100))

Set(test2,DataCardValue14.Text * ((DataCardValue7.Text *.01) + 1))

[v-monli-msft · Accepted solution]

Hi @JasonMilwaukee2 ,

You could use below formulas to achieve this:

If(SharePointForm1.Mode=New,test1,ThisItem.ColumnName1)

If(SharePointForm1.Mode=New,test2,ThisItem.ColumnName2)

Regards,

Mona