https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/120149.aspxFri, 07 Dec 2018 15:52:57 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120149Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/120149.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120149So - I see you found a work around, that's great. NaN stands for not a number.... Here's a blog post that may be helpful in the future: http://www.braintrove.com/id/71https://www.infopathdev.com:443/forums/thread/120072.aspxThu, 15 Nov 2018 19:25:24 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120072benefishall0https://www.infopathdev.com:443/forums/thread/120072.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120072Hello, 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.