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/104196.aspxThu, 01 Oct 2015 14:50:57 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:104196Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/104196.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=104196<p>So - this is a default value in a field inside the repeating table?</p><p>If so:</p><p>sum(xdXDocument:GetDOM(&quot;Staffing Report&quot;)/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Opens[../d:Band_x0020_ =current()/../my:Band and ../d:Work_x0020_City = xdXDocument:get-DOM()/my:myFields/my:LocationDropdown and ../d:_x0033__x002d_Dot_x0020_Hierarch = current()/../my:Hierarchy])</p><p>If that doesn&#39;t do it, you can attach a copy of your form under the Options tab in a&nbsp;reply and I can&nbsp;give you a hand.&nbsp;</p>https://www.infopathdev.com:443/forums/thread/104194.aspxThu, 01 Oct 2015 14:38:55 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:104194orbanez0https://www.infopathdev.com:443/forums/thread/104194.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=104194Hello, I have a repeating table where I want to calculate a sum, based on a few criteria. In the image I have uploaded, the user selects the Location, and then populates a financial Hierarchy and Band (job level). Based on those criteria, I have a formula as the default value that queries a SharePoint list of HR data, matches the variables the user has populated in each line of the repeating table to the data and outputs a sum. I have this working but as I add rows descending, I find that the formula outputs the same sum regardless of the difference in variables on each row of the repeating table. I understand I need to somehow incorporate CURRENT into my formula but I can not! The formula is currently populated as: sum(xdXDocument:GetDOM(&quot;Staffing Report&quot;)/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Opens[../d:Band_x0020_ = xdXDocument:get-DOM()/my:myFields/my:Group/my:RepeatingFields/my:Band and ../d:Work_x0020_City = xdXDocument:get-DOM()/my:myFields/my:LocationDropdown and ../d:_x0033__x002d_Dot_x0020_Hierarch = xdXDocument:get-DOM()/my:myFields/my:Group/my:RepeatingFields/my:Hierarchy]) Where can I incorporate &#39;current()/&#39; so that the sum is calculated properly for each row? Thank you!