Incorrect count result using conditional rule.

[dmonty]

I want to count the number of occurances where 'field1' is not blank and
'field2' is blank. Both fields are contained in a repeating section. The
conditional rule results in count = zero. My objective is to count the number
of open issues ('OpenDate' not = blank and 'ClosedDate' = blank). Any
suggestions on how to do this?

 

[S.Y.M. Wong-A-Ton]

Where is the field that is doing the counting located? In the repeating table
too? Or outside it somewhere?

 

[dmonty]

The count is located within the repeated section where OpenDate and
ClosedDate reside.

 

[S.Y.M. Wong-A-Ton]

Try using "preceding" or "preceding-sibling" when using the count() function
as demonstrated in this tutorial:
http://www.infopathdev.com/howto/tutorials/default.aspx?i=d663d7df90e94e65abb02632966e8127

and combine this with the filtering technique demonstrated in the post in
this newsgroup entitled 'total fields using "is not blank"'.