General

Re: Count multiple values in repeating table

rdrnnr — Fri, 18 May 2012 17:39:37 GMT

great, I'll give it a try. I appreciate your assistance! Have a great weekend!

Re: Count multiple values in repeating table

Jimmy — Fri, 18 May 2012 17:30:22 GMT

In that case, I think the following should allow you to count how many fields with each response there are:

count(//*[starts-with(local-name(), 'gpsresp')][. = 'Pass'])

Re: Count multiple values in repeating table

rdrnnr — Fri, 18 May 2012 17:06:30 GMT

yes, the dropdowns in that section all start with gpsresp then the number of the question. The comment boxes start with gpscom then the number of the question (text box).

Re: Count multiple values in repeating table

Jimmy — Fri, 18 May 2012 16:56:17 GMT

Almost. I wanted to see the contents of the Data Source taskpane (see where it says Data Source on the right side of your first screenshot?) But this may be enough. Do all the dropdown boxes have a name starting with gpsresp, and are the dropdowns the only fields with names like that?

Re: Count multiple values in repeating table

rdrnnr — Fri, 18 May 2012 16:25:33 GMT

Oops sorry. I've opened the data source (control) and screen shot that. Is this what you're looking for?

Re: Count multiple values in repeating table

Jimmy — Fri, 18 May 2012 16:14:15 GMT

It seems you have attached a screenshot of the form's layout, but not its data source. I need to see what the data source looks like in order to help you.

Re: Count multiple values in repeating table

rdrnnr — Fri, 18 May 2012 16:04:35 GMT

Have attached a screen shot. In the drop down, have options of selecting 'pass' 'finding' or 'discrepancy'. Thanks.

Re: Count multiple values in repeating table

Jimmy — Fri, 18 May 2012 15:53:25 GMT

That would depend on how your data source is structured. Could you attach a screenshot of enough to give us an idea of how you've organized it?

Re: Count multiple values in repeating table

rdrnnr — Fri, 18 May 2012 15:38:01 GMT

I like easier ways... I have a checklist asking a question with a drop down control with answers (these are the ones I want to count) and then a comment text box. I've used the count method you mention above, however, it limited me on the number of fields I could count to something like 40 (ish). I have 182 questions. Is there an easier way to count them? Thanks.

Re: Count multiple values in repeating table

Jimmy — Fri, 18 May 2012 15:29:08 GMT

Depending on your data source is organized, there may be a simpler way, but generally for disparate fields, the way to count how many have a certain value is:

count((firstField | secondField | ... | lastField)[. = 'pass'])

Re: Count multiple values in repeating table

rdrnnr — Fri, 18 May 2012 14:10:27 GMT

Will that formula work if the items you want to count are not in a repeating table? In other words, I have over 100 controls and want to count them if they = pass or = deficiency.

Re: Count multiple values in repeating table

Hilary Stoupa — Mon, 26 Mar 2012 15:48:36 GMT

At the point where you are adding the filter, you are already at the child node. You have to use the relative path - in fact, you were using a relative path, but relative to the node the default was on. The error kind of tells you what was going on - it said that this:

../../OptGroup_EQUIPMENT/EQUIPMENT/equipmenttype/EquipInsp

Did not point to a field or group.

Re: Count multiple values in repeating table

Laura — Mon, 26 Mar 2012 10:56:27 GMT

Great, this works, I am thrilled. Thank you for your time.

Could you explain why using the full xpath did not work for the second reference (equipinsp = fail)? It seems like using the full path would always work.

Re: Count multiple values in repeating table

Hilary Stoupa — Fri, 23 Mar 2012 15:03:14 GMT

Oh, I made a mistake!

count (../../OptGroup_EQUIPMENT/EQUIPMENT/equipmenttype[. = "Ladder" and ../EquipInsp = 'Fail'])

Re: Count multiple values in repeating table

Hilary Stoupa — Fri, 23 Mar 2012 15:00:13 GMT

What field are you setting the default value on?