Incorrect count result using conditional rule.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dmonty - 05 Apr 2006 13:51 GMT

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?

Reply to this Message

S.Y.M. Wong-A-Ton - 05 Apr 2006 14:48 GMT

Where is the field that is doing the counting located? In the repeating table
too? Or outside it somewhere?
---
S.Y.M. Wong-A-Ton

> 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?

Reply to this Message

dmonty - 05 Apr 2006 17:48 GMT

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

> Where is the field that is doing the counting located? In the repeating table
> too? Or outside it somewhere?
[quoted text clipped - 6 lines]
> > of open issues ('OpenDate' not = blank and 'ClosedDate' = blank). Any
> > suggestions on how to do this?

Reply to this Message

S.Y.M. Wong-A-Ton - 06 Apr 2006 08:02 GMT

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=d663d7df90e94e65abb026
32966e8127

and combine this with the filtering technique demonstrated in the post in
this newsgroup entitled 'total fields using "is not blank"'.
---
S.Y.M. Wong-A-Ton

> The count is located within the repeated section where OpenDate and
> ClosedDate reside.
[quoted text clipped - 9 lines]
> > > of open issues ('OpenDate' not = blank and 'ClosedDate' = blank). Any
> > > suggestions on how to do this?

Reply to this Message