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/121940.aspxMon, 11 Nov 2019 18:28:52 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121940Fatihteke0https://www.infopathdev.com:443/forums/thread/121940.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121940Hilary I don't know how can i thank you? :) its working as like as i want. Thank you so so much. Best Regardshttps://www.infopathdev.com:443/forums/thread/121938.aspxMon, 11 Nov 2019 15:40:47 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121938Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/121938.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121938sum(../d:SharePointListItem_RW/d:l8xb[../d:Title = current()/d:Title]) - note how my formula goes up to the repeating node to summarize - ../d:SharePointListItem_RWhttps://www.infopathdev.com:443/forums/thread/121937.aspxSun, 10 Nov 2019 19:10:54 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121937Fatihteke0https://www.infopathdev.com:443/forums/thread/121937.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121937Yes Hilary its correct. But your formule summirized "Name" I want to for product Numbers. If I change the code for numbers like this "sum(d:l8xb[../d:Title = current()/d:Title])" Its only show first number. not sum.https://www.infopathdev.com:443/forums/thread/121916.aspxThu, 07 Nov 2019 23:22:54 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121916Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/121916.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121916Ok. So the data is directly entered into the SharePoint list and you are just using the InfoPath form to display the data summarized. Is that correct? If so - try this copy, where I have added the calculated field for you with the formula I've suggested. Save the form locally. Right click the template and select Design. Then you can preview and see if it works as anticipated.https://www.infopathdev.com:443/forums/thread/121915.aspxThu, 07 Nov 2019 20:17:21 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121915Fatihteke0https://www.infopathdev.com:443/forums/thread/121915.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121915Actualy I want to create this form for custormers purchaces. One person will add lines to my list everyday custormers purchaces. My target to sum all products count which have same code. For example today I create 3 order for 3 different customer and products codes is A1,B1,C1. and item count A1=10,B1=20,C1=30 tomorrow i insert to new lines to mo sharepoint list and A1=100,B1=30 and of day manager must to see we need 110 A1 product, 50 B1 product an 30 C1 product. After that manager will give order to producer and request them correct count. 1 week later procuder send A1 and B1 products to us and we click the checkbox "order complate" and we will see only C1 product for complate. This will continue forever.https://www.infopathdev.com:443/forums/thread/121914.aspxThu, 07 Nov 2019 19:59:58 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121914Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/121914.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121914My example is bound to the main data source for a reason. Do you need to store the data the user enters into that count field? Because data entered into secondary data source fields won't get saved when the form is submitted.https://www.infopathdev.com:443/forums/thread/121913.aspxThu, 07 Nov 2019 19:55:52 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121913Fatihteke0https://www.infopathdev.com:443/forums/thread/121913.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121913and if i insert summary column in my sharepoint list i couldn't control it for formule.https://www.infopathdev.com:443/forums/thread/121912.aspxThu, 07 Nov 2019 19:53:08 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121912Fatihteke0https://www.infopathdev.com:443/forums/thread/121912.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121912Yes Field2 is not repeating table. Because its Count's target. Count is calculated value and Xpath is Filed2. And Field2 formule i write it above. I am confuse because in your example you create field3 and field3 is calculating. I think so my mistake is filed2 must be in rebeating table rigth?https://www.infopathdev.com:443/forums/thread/121910.aspxThu, 07 Nov 2019 19:30:49 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121910Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/121910.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121910That screen shot is of field2, which is not repeating, and doesn't show the XPath, which based on what I saw and what was in the form, is not what I pasted in. Can you try the XPath I pasted in for your expression box in your repeating table? Instead of field2?https://www.infopathdev.com:443/forums/thread/121909.aspxThu, 07 Nov 2019 19:22:27 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121909Fatihteke0https://www.infopathdev.com:443/forums/thread/121909.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121909Hello Hilary, Its already like that.I used same code like you.https://www.infopathdev.com:443/forums/thread/121907.aspxThu, 07 Nov 2019 15:34:30 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121907Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/121907.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121907The main issue I see here is that field2 is not repeating, so I'd guess it would always display the same value. My guess would be you could use this for your calculated value in the "Filtered" table: sum(../d:SharePointListItem_RW/d:l8xb[../d:xqnm = current()/d:xqnm])https://www.infopathdev.com:443/forums/thread/121905.aspxWed, 06 Nov 2019 18:44:43 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121905Fatihteke0https://www.infopathdev.com:443/forums/thread/121905.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121905Hello Everyone, I found this article. https://www.infopathdev.com/forums/p/11050/39728.aspx In this article Hilary create awesome template which name is summary.xsn. I want to create same thing but not manuely select. I want to do it with list items. Thats why i copyed code and change it like this Original: sum(/my:myFields/my:group1/my:group2/my:field2[../my:field1 = current()/../my:field1]) My Code: sum(xdXDocument:GetDOM("Siparis-Data")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:l8xb[xdXDocument:GetDOM("Siparis-Data")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:xqnm = current()][xdXDocument:GetDOM("Siparis-Data")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:xqnm]) But it return 0. Where is my mistake? I attach xsn.