Newbie Questions

Re: Count Repeating Table

samdany10 — Tue, 07 Jan 2014 16:03:17 GMT

Hillary, How to find the number of 'http' found in this srting http://Test:88/Lists/attachment/Attachments/9/2012_CalculateYourBudget.xlshttp://Test:88/Lists/attachment/Attachments/9/44849854_1382617697423.pdfhttp://Test:88/Lists/attachment/Attachments/9/AbhikRoyChowdhury.dochttp://Test:88/Lists/attachment/Attachments/9/BegSP_2013_development.pdfhttp://Test:88/Lists/attachment/Attachments/9/Capture1.PNGhttp://Test:88/Lists/attachment/Attachments/9/PictureFieldTemplate3.txt

Re: Count Repeating Table

samdany10 — Tue, 07 Jan 2014 15:49:25 GMT

Shep123, Really thanks for immediate response, let me try.

Re: Count Repeating Table

shep123 — Tue, 07 Jan 2014 15:23:29 GMT

samdany10, I did this a ways back so I don't really recall the situation. But I'm pretty sure Hilary's answer was what I added. I think I thought I had applied to the filter when I clearly hadn't. Hope that helps.

Re: Count Repeating Table

samdany10 — Tue, 07 Jan 2014 15:12:54 GMT

shep123:
And now I feel dumb. I had that equation and it wasn't working. I must of had a typo or something. Thanks anyway Hilary!

Hi Shep123, Did you find any solution for this issue?

Re: Count Repeating Table

shep123 — Thu, 21 Jun 2012 16:34:11 GMT

And now I feel dumb. I had that equation and it wasn't working. I must of had a typo or something. Thanks anyway Hilary!

Re: Count Repeating Table

Hilary Stoupa — Thu, 21 Jun 2012 16:29:00 GMT

So, is the above XPath getting you the correct count of all rows? If so, you can just add a filter:

count(../../my:repeatingGroup/my:repeatingTable/my:uomRepeatingTable[my:ColumName = 'Smith'])

But instead of ColumnName above, you'd use the actual name of the field that would contain "Smith".

Re: Count Repeating Table

shep123 — Thu, 21 Jun 2012 15:43:49 GMT

This is the current XPath of the rule if it helps anyone:
count(../../my:repeatingGroup/my:repeatingTable/my:uomRepeatingTable)

Count Repeating Table

shep123 — Thu, 21 Jun 2012 15:41:43 GMT

My question is fairly similar to this question (http://www.infopathdev.com/forums/p/6773/24839.aspx) regarding values in a repeating table. Unless someone needs the additional information I won't delve into exactly how my form is operating. Basically I am trying to count values in a column of a repeating table that satisfy a requirement. The previous question wanted to count the distinct values in Smith, Bird, Smith, Walker. I would like to be able to count the amount of times Smith occurs in a column. I would essentially be doing the CountIf function in excel. Thanks!