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/101633.aspxTue, 10 Mar 2015 15:29:37 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:101633DDEBBABY0https://www.infopathdev.com:443/forums/thread/101633.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=101633<p>Omg thanks so much that is exactly what I was looking for!!!!!&nbsp; You are a life saver :)</p>https://www.infopathdev.com:443/forums/thread/101631.aspxTue, 10 Mar 2015 15:21:17 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:101631Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/101631.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=101631<p>So - field2 should be the sum of Qty where Lead Type&nbsp;is equal to field4?</p> <p>sum(../my:details[my:leadType = current()/../my:field4]/my:qty)</p>https://www.infopathdev.com:443/forums/thread/101628.aspxTue, 10 Mar 2015 15:09:09 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:101628DDEBBABY0https://www.infopathdev.com:443/forums/thread/101628.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=101628<p>Please help I has a repeating table that has severla fields on it.&nbsp; There is a sum field based on quanity of units field that curently sum of anything in the QTY FIELD.&nbsp; I need to change this to sum based on what is selected from the lead type and sum only that lead type.&nbsp; Does anyone hav any suggestions ?</p>