InfoPath Dev

Is it possible to count a checkbox field if it is Yes in a repeating table.

Say there are 10 rows and 6 of those rows the checkbox is checked.

The count would show 6.

count(../my:Repeating_Row_Overhead/my:Invoice_Receipt = "yes")

Doesn't seem to work - it doesn't - fail.

If I try count(current()../my:Repeating_Row_Overhead/my:Invoice_Receipt = "yes")

Fail.

I am clutching at straws and any guidance - even an answer would be appreciated and thank fully used.

Where is the expression box or field where you are are using this expression?

I'd think the expression would be something like this:

count(../my:Repeating_Row_Overhead[my:Invoice_Receipt = "yes"])

If the field / placement is inside the group

I'm attaching a sample.

Hi Hillary,

The expression box is part of the footer.

Hillary you are the one.

Fantastic - all good and working.

Many many thank you's.