How to calcuate percent change in Infopath

Question

Hi maybe someone out there can help me.  I need to calculate percent change in an InfoPath form services form. 

Using Excel, the formula would be: (NewSalary - OldSalary)/ABS(OldSalary).

Unfortunately, InfoPath 2007 does not seem to offer an ABS function.  I tried using an xpath expression with fn:abs(OldSalary) but no luck.

Thanks in advance for your help,

Jonathan

Answer 1

Why do you need an ABS function?  Can't you just do the basic math formula of ((NewSalary - OldSalary)/OldSalary)*100 or (NewSalary - OldSalary)/OldSalary if the field is already set to display as a percentage?

---

SharePoint Architect || Microsoft MVP || My Blog
Planet Technologies || SharePoint Task Force