Newbie Questions

Re: Logical AND Operator

Hilary Stoupa — Thu, 19 Dec 2013 15:31:20 GMT

Hooray! so what that XPath says is:

Count the instances of the group2 node where inside that node both of these fields are equal to yes.

Re: Logical AND Operator

jedlo — Thu, 19 Dec 2013 15:20:32 GMT

That worked! Thanks for your help!

Re: Logical AND Operator

Hilary Stoupa — Thu, 19 Dec 2013 15:13:45 GMT

Try this - I'm assuming you picked your fields with the field picker so the ../my:group1/my:group2 relative path is correct:

count(../my:group1/my:group2[my:dataMSM = "yes" and my:dataTested = "yes"])

Re: Logical AND Operator

jedlo — Thu, 19 Dec 2013 15:06:17 GMT

Thanks for the reply Hilary. I tried building a new formula from your example, but didn't have much luck. Here is the full XPath from one of my previous attempts:

count(../my:group1/my:group2/my:dataMSM = "yes" and ../my:group1/my:group2/my:dataTested = "yes")

This throws the error: "Argument 1 must return a node-set."

Re: Logical AND Operator

Hilary Stoupa — Thu, 19 Dec 2013 02:01:19 GMT

Is this the full XPath? Can you check the Edit XPath box in the formula editor?

At any rate, I'd think you want to count the rows where the values are true - without knowing the XPath to your nodes, I have to make something up here, but I'd expect something like:

count(groups/group[dataMSM = 'yes' and dataTested = 'yes'])

So, in the formula editor, select the repeating group. Add a filter, and the filter would be that dataMSM is yes and dataTested is yes - does that make sense?

Logical AND Operator

jedlo — Wed, 18 Dec 2013 19:38:08 GMT

I have a form that uses a repeating group, and a totals section to tally selections in the repeating group rows. For example, the repeating group has two check boxes, dataMSM and dataTested. Above the repeating group, there are three fields totalMSM, totalMSMTested and totalTested. The totalMSM and totalTested fields are set to increment like this:

count(dataMSM[. = "yes"])
count(dataTested[. = "yes"])

These both work perfectly. Each time a row is added and these check boxes are checked, the correct fields increment by one. However, the totalMSMTested field should only increment if both dataMSM AND dataTested are checked. I've tried the following and each fails the validation:

count(dataMSM[. = "yes"] and dataTested[. = "yes"])
count((dataMSM and dataTested)[. = "yes"])
count(((dataMSM) and (dataTested))[. = "yes"])

Any ideas on how I can get the totalMSMTested field to increment only if both dataMSM AND dataTested are checked?

Thanks!