General

Re: NaN error when adding up two double values

gerwinee — Mon, 12 Apr 2010 10:11:56 GMT

Did anybody tried to deploy the sample I included in my previous post and did that work without problems?

Re: NaN error when adding up two double values

Patrick Finnicum — Fri, 02 Apr 2010 11:04:57 GMT

hmmmm.... i can't reproduce it either. have you tried deleting the textboxes and starting over? Try that, but start with only one rule. If that works, then add the other. Start small and build your way up.

Sorry I don't have more for ya, but I can't get it to fail on my end.

Re: NaN error when adding up two double values

gerwinee — Thu, 01 Apr 2010 13:12:25 GMT

How can i use 12,50 then? Because 12.50 isn't allowed either.

Re: NaN error when adding up two double values

Patrick Finnicum — Wed, 31 Mar 2010 12:40:25 GMT

NaN is an error code returned by Javascript (hence why it only appears in a browser). It stands for Not A Number. I'd check the values of the numbers your adding up, and ensure that they have numbers in them (and are not null).

if one of the variables is as you posted "12,50", then that's a problem because of the comma -- which is then interpreted to be text string.

Re: NaN error when adding up two double values

gerwinee — Wed, 31 Mar 2010 11:19:53 GMT

The problem only appears when i use it in a webbrowser.

Re: NaN error when adding up two double values

Jimmy — Wed, 31 Mar 2010 10:18:52 GMT

Might you be able to attach a stripped-down version of your form that can reproduce this issue? I can't seem to get it to happen on my end.

NaN error when adding up two double values

gerwinee — Wed, 31 Mar 2010 09:58:44 GMT

I use InfoPath 2007.

I tried to do the following.
Select a check box and the following rule will be applied: total = total + articlePrice
When i uncheck the check box the following rule will be applied: total = total - articlePrice

It works fine, until articlePrice has decimals in it (12,50) and i want to save or close the field, then i get a NaN error or i get the message than only numbers are allowed.

I've tried the following sollution, but with no luck. http://blogs.msdn.com/infopath/archive/2008/04/17/invalid-data-error-when-calculating-the-result-of-2-or-more-fields.aspx

total and articlePrice are both TextBox with data type Decimal (double)
total has a default value of 0.