InfoPath Dev

Here's a sample - save locally, right click & select design, then preview. I'm just summing the previous numberapproved and adding in the current in mine. I think for your schema the formula for the default value for totalnumberapproved would be: sum(../preceding-sibling::my:yearrpanel/my:numberapproved) + ../my:numberapproved

 Sorry, I cant see the image so this is the field structure:   -myFields     +queryFields     -dataFields         +d:ASL_Finished_Good                +ASL_Raw_Material                        ...

 Here's a blog post from Greg Collins from back in 2005 that I still refer to for help with the preceding-sibling axis, in case it is helpful for you as well: https://www.infopathdev.com/blogs/greg/archive/2005/06/13/Using-XPath_2700_s-_2700_preceding_2D00_sibling_2700_-Axis-Correctly.aspx

 Hello Hilary, thanks for speedy response. I'm not getting this - I've used Jimmy's concat(substring('000', 1, 3 - string-length(field)), field) and get this to work amd shows 000's but what am I supposed to do with these? I have a repeating table with a textbox called "ScopeID" in the 1st row - ...

Thank you Hilary, It worked like a charm, and gave me an overall understanding of preceding siblings. I have been reading and using your information for years, and am a big fan. Thank you, Shlomo

Good afternoon, I have a repeating section, where contains two relevant number fields. The first is where the user inputs a number, and the second totals it, adding that number with the previous total of the last section, placing it in this section's ...

I've attached a sample form. Right click the linked form, select save as to save locally. Right click the saved form, select Design to open in design mode, then preview. I used your XML as a secondary data source. I think there may be two issues with your formula - but I don't know how your form is set up. That is, I don't know where ...

I know this is an older thread but hoping for some assistance. My XML (nodes) look like this - replacing the arrow brackets with round for formatting ...

Hi Just an additional observation When i try to use ../preceding-sibling::my:SharePointListItem_RW[5]/my:Parent Risk ID - I get Error as Expected value type: end-of-string Wehn i try to use ../preceding-sibling::my:SharePointListItem_RW[5]/my:ID - I don't get above error. Both are valid columns in my ChlidList. It means it gives ...

I've attached a sample - right click and save locally, right click, select design and preview. Add some rows to the repeating table, and set some of the fields to the same value. For your formula, I'd try: ...