InfoPath Dev

Ok this seems really simple but I'm terrible with formulas. I'm creating a form and I need one column (last year Annual Salary) and another column (this year Annual Salary) to spit out the percentage increase in salary into a third column (Percentage) I know in Excel the forumla would be =(B2-A2)/A2 but how do I work this in Infopath? A total newb question I know. Thank you!

You can use a formula like (ThisYearSalary - LastYearSalary) div LastYearSalary as the default value formula for the Percentage field.  You can use the Insert Field... button to help you with selecting the right fields.

Success! Yes that totally worked thank you Jimmy. So only one more question the numbers are coming out with a 0. before them (ie 50% is coming out 0.5) I can't see anyway to format that control to a percentage. Is there a formula to do so? Thank you again for all of your help.

If you're using an Expression Box, you can select Decimal in the Format As option, and then click Format, you can select percentage.  This will basically just show the number multiplied by 100 with all of the remaining digits as a fractional part.

You can instead use a formula like

concat(floor(my:Percentage * 100), " %") 

to show only the whole number part of the percentage and a % symbol.

That formula you entered would it be before or after my formula to figure out the percent (FromSalary - ToSalary) / FromSalary

Never mind I totally got it. Thank you again Jimmy you're a genius.