https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/4120.aspxSun, 25 Feb 2007 21:24:13 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:4120Patrick Halstead0https://www.infopathdev.com:443/forums/thread/4120.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=4120Hi Kathie and welcome to our forum!<br />The sum will calculate all entries at once. If you want a running balance, you'll have to use preceding-sibling as your opening balance and subtract the current line item. Search the forum (upper right) and site (upper left) for preceding-sibling() and current() to find references to how to use those xpath functinons. Good luck!<br />https://www.infopathdev.com:443/forums/thread/1873.aspxFri, 23 Feb 2007 08:15:11 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:1873KathieDamsel0https://www.infopathdev.com:443/forums/thread/1873.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=1873Hello, I am new to InfoPath and need some help badly!<br /><br />I would like to make a form consisting of a repeating table with 4 columns, namely: Description, Debit, Credit, and Balance. <br /><br />The table header should have “opening balance” appears under “description” column, and some fixed number appears under “debit” column.<br /><br />On the “balance” column, I#%92ve used ../../my:opening balance – sum(my:debit) + sum(my:credit) formula. However, I#%92ve been getting a wrong result for “balance”. See below for example.<br /><br />I want the following:<br />Description Debit Credit Balance <br />Opening Balance $100 $0 $100 <br />Books $5 $0 $95<br />Lunch $8 $0 $87<br />Weekly Allowance $0 $50 $137 <br /><br /><br />Unfortunately, what I#%92m getting is:<br />Description Debit Credit Balance <br />Opening Balance $100 $0 $100 <br />Books $5 $0 $95<br />Lunch $8 $0 $92<br />Weekly Allowance $0 $50 $150<br /><br /><br />Any tips/advice is certainly appreciated. <br />Thanks,<br />Kathie<br />