InfoPath Dev

Hi All,

I got something strange going on now....
In a browser formular i do some math and it all looks good.

When i save the document the fields are getting cirkeld red and i get NaN values...
What am i doing wrong ?

 Thanks in advance

Probably you have the wrong data type for the value you are generating. Make sure you are using a decimal/double value and it should work. Best of luck!

i checked and double checked it....but the types are on decimal / double

the values are chaning when i push the save button

when i change the number in the field where the calculatings are on then it's normal again......HELP

Hi again,

Are you using a SharePoint List Form or an InfoPath Form Library form? The former will likely convert the values to SQL data types on submit since the SharePoint List Forms do not store XML. The latter, however, should roundtrip the XML data types correctly.

I'm using an Sharepoint List Form.

Don't know exactly what you mean by " the latter" but is there a solution for my problem ?

Thanks in advance.

Hey JappieJ!

OK, the reason is that the data types aren't roundtripped with list forms. The InfoPath list forms save the data to a table on SharePoint. That table is stored in SQL so the data types must be converted to SQL and then roundtripped. So, you are seeing this problem. If you use an InfoPath Form Library, it will save the data as XML and will roundtrip with 100% fidelity. :)

Happy trails!