https://www.infopathdev.com:443/forums/44.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/123089.aspxTue, 09 Jun 2020 18:38:39 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123089Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/123089.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=123089We found the issue - since Area was a lookup in the secondary list, we needed to change the filter to use ID instead: count(xdXDocument:GetDOM("RDT List Count Status")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Area[. = current()/../my:ID and ../d:Status = "In Service"])https://www.infopathdev.com:443/forums/thread/123084.aspxMon, 08 Jun 2020 21:12:13 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123084deryozzy0https://www.infopathdev.com:443/forums/thread/123084.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=123084Hi Hilary would it be okay if I sent you a PM??https://www.infopathdev.com:443/forums/thread/123083.aspxMon, 08 Jun 2020 14:49:03 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123083Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/123083.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=123083I think you'll have to find a way to get me the template, I'm afraid. When you have the template in design mode, can you navigate to File > Save As to save a copy? And then attach the saved file to a reply?https://www.infopathdev.com:443/forums/thread/123082.aspxSun, 07 Jun 2020 10:45:10 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123082deryozzy0https://www.infopathdev.com:443/forums/thread/123082.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=123082Hi Hilary, I have tried the new formula and it's still returning a value of 0, in saying that I hope that I applied it correctly, it checked the XPath option in the formula box and pasted in the new formula. Thanks so much for your help, Deehttps://www.infopathdev.com:443/forums/thread/123076.aspxThu, 04 Jun 2020 15:07:45 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123076Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/123076.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=123076So this is a default value in a field in the main data source in the form? I'd guess this might work: count(xdXDocument:GetDOM("RDT List Count Status")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Area[. = current()/../my:Title and ../d:Status = "In Service"])https://www.infopathdev.com:443/forums/thread/123075.aspxThu, 04 Jun 2020 11:07:42 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123075deryozzy0https://www.infopathdev.com:443/forums/thread/123075.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=123075Hi Hilary, The Xpath is as follows: count(xdXDocument:GetDOM("RDT List Count Status")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Area[. = xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:Title and ../d:Status = "In Service"]) Thanks!!!!https://www.infopathdev.com:443/forums/thread/123070.aspxWed, 03 Jun 2020 20:14:29 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123070Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/123070.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=123070In the formula editor, can you check the Edit XPath option and paste the XPath into a reply?https://www.infopathdev.com:443/forums/thread/123066.aspxWed, 03 Jun 2020 09:34:46 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123066deryozzy0https://www.infopathdev.com:443/forums/thread/123066.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=123066Hi Hilary, I tried a few times to save as template but am having no luck. It may be something to do with the company permissions. What I have tried is I am opening Area list in Infopath and have setup a data connection to the second list (pulling the Fields "Area" and "Status") then in Area List in Field called In Service I have set the default value to count(Area[. = Title and Status = "In Service"]) So count in List 2 (using second data connection and fields selected from dataFields) the field Area and then filtered to Area (second data conn) = Title (Main Connection) AND where Status (Second Connection) = In Service (in correct case) . All fields have been selected from the dataField drop down for both connections. This always returns a value of 0, when there should be a higher value. I'm obviously missing something??? I hope I explained that okay. Any advice you could give would really be appreciated. Deehttps://www.infopathdev.com:443/forums/thread/123046.aspxWed, 27 May 2020 14:52:02 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123046Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/123046.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=123046Any chance you can attach your template (under the Options tab in a reply) - the XPath filter for this will depend on your data sources.... Also, just in case you weren't aware, XPath is case sensitive, so if your list data is actually "In Service" instead of "In service" for example, you won't get a match on that text :)https://www.infopathdev.com:443/forums/thread/123043.aspxWed, 27 May 2020 11:15:07 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123043deryozzy0https://www.infopathdev.com:443/forums/thread/123043.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=123043Hi, I am really struggling with this and I'm hoping someone will be able to help! I have two lists List A (Area) and List B (Units). List B has a Lookup field (called Area) to List A (Column "Title"). List B has a status field which can one of two Status - "In service" and "Out of service". I have two fields in List A called "In service" and "Out of service"so beside each Area item I want to show a count in the field "In service" where all the items in List B Area field is equal to List A Title Field AND Status is equal to "In service" I have tried a few ways to do this and cant find anything that works . Thanks in advance to anyone that may have any insight!!! Dee