General

Re: Count Checkboxes that are "Yes" in a repeating table

wapfunz — Tue, 01 May 2012 01:33:23 GMT

Hillary you are the one.

Fantastic - all good and working.

Many many thank you's.

wapfunz — Tue, 01 May 2012 01:27:49 GMT

Hi Hillary,

The expression box is part of the footer.

Hilary Stoupa — Tue, 01 May 2012 00:26:25 GMT

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.

wapfunz — Tue, 01 May 2012 00:08:12 GMT

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.