Infopath Repeating Section

I am working on a Infopath form with a repeating section that has four fields.

txtPreviousOnHand
txtRecived
txtSent
txtOnHand


I have it set so that "txtOnHand" is calulated by txtRecieved - txtSend.  So if we Recived 10 boxes and sent 8 boxes, we should have 2 boxes on hand.  txtPreviousOnHand has an Function value of "number(preceding-sibling::my:txtOnHand)", so the next repeating row would start with a txtPrevioiusOnHand of 2.

The problem comes into play when we create an additional row in the repeating section.  The txtPreviousOnHand field is suppose to pull the txtOnHand value from the PREVIOUS row, and it does work about 75% of the time.  FOr some reason the other 25% of the time, I get a "NaN" error.  This error seems to be random.  It can happen on the second repeating row or the seventh.

Any help would be GREAT!
tyty4u2Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
Advertise Here
 
tyty4u2Connect With a Mentor Author Commented:
I found the solution by using the following xpath.

../preceding-sibling::my:group2[1]/my:field1
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.