InfoPath Dev

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!

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?

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." 

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"]) 

 That worked! Thanks for your help!

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.