Share via

InfoPath "NaN validation error"

Anonymous
2011-07-13T20:22:13+00:00

I am multiplying two form fields and placing the result in a third field. I am getting a correct answer in the third field but that's when I am getting this error. Anyone know why this is happening? Thanks in advance.

Microsoft 365 and Office | Install, redeem, activate | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2011-07-16T17:46:37+00:00

Thanks Hillary - I found the problem. I needed to use the ROUND function since the answer was creating too big of a field for the DB field.

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-07-14T00:00:26+00:00

    I'm pretty sure NaN stands for "Not a Number" - but you say you are getting the right result? Have you tried the number function on your field values?

    number(field1) * number(field2)

    Was this answer helpful?

    0 comments