https://www.infopathdev.com:443/forums/46.aspx For questions concerning issues in the integration of SharePoint and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/40944.aspxFri, 24 Apr 2009 05:12:05 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:40944swathip0https://www.infopathdev.com:443/forums/thread/40944.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=40944<p>Hi,</p> <p>Use the following expression to count the number members.</p> <p>count(/my:myFields/my:group1/my:group2[my:field2 != &quot;&quot;])</p> <p>&nbsp;</p> <p>Just add a filter to count only the fields which are not empty.</p> <p>Here /my:myFields/my:group1/my:group2 is a repeating table xpath.</p>https://www.infopathdev.com:443/forums/thread/40903.aspxThu, 23 Apr 2009 09:22:31 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:40903hokutolegacy0https://www.infopathdev.com:443/forums/thread/40903.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=40903Hi ! here&#39;s my problem : i use 4 repeating tables for my subscription form where people have the choice to add members Then I display the names in a column (i use the &quot;merge&quot; function) but i also need to know the amount of people so i add a new column &amp; use the &quot;count&quot; function BUT some repeating tables are optional but my count function still return a &quot;1&quot; even if the first field is empty, it&#39;s logic i know but i want a &quot;0&quot; or nothing... Can somebody help me with this case ?