https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/22521.aspxWed, 22 Aug 2007 06:32:03 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:22521Shiva0https://www.infopathdev.com:443/forums/thread/22521.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=22521<p>Hi Ben, </p> <p>In your first formula you are getting preceding sibling of total node right? And other one is related to calculation on some other fields? Is it related to those repeating section nodes or not? Can you give your schema once where these fields are located? </p> <p>Hope this help you </p>https://www.infopathdev.com:443/forums/thread/22275.aspxFri, 10 Aug 2007 09:35:02 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:22275ninjaben0https://www.infopathdev.com:443/forums/thread/22275.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=22275<p>hi,</p><p>&nbsp;Could you please help me and merging these two formulas into one, so they can work together </p><p>&nbsp;One of them is to get a previous value from a repeating table,</p><p>&nbsp;../preceding-sibling::my:group2[1]/my:Total</p><p>&nbsp;and the other one is for calculating fields</p><p>&nbsp;(../../../my:Initial_load + ../my:issue_of_stock) - ../my:removal_of_stock</p><p>&nbsp;</p><p>Many thanks in advance</p><p>&nbsp;</p><p>Ben</p><p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p>