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,
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?
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?