Hello,
I'm using InfoPath Designer 2013 and calculating a couple of fields to reflect a negative percentage and getting the dreaded NaN upon previewing and uploading to SharePoint.
Using the formula ((field21 - field20) / (field20) * 100), all seems to work exactly how I need it to but when yo go to Submit I get the below error:
"The form cannot be submitted.
One or more fields have invalid values and cannot be submitted to the list.
Invalid number value.
A number field contains invalid data. Please check the value and try again."
Any help would be greatly appreciated.
Thanks
John
~Update~
I was able to remedy my situation by creating a Rule on each field with Condition of "if Field X contains "NaN" then Set a fields value of blank". The lousy part is that I had to do that to 50 fields. Hopefully this doesn't cause issues in the future going forward.