Newbie Questions

Re: How to count non blank fields in Infopath forms?

TSKoo — Tue, 28 Feb 2012 16:18:52 GMT

Jimmy,

I need to count a field which will have different values. For example. the value in field paymentstatus.code can be 'ISSUED' or 'FORMATTED'. Can you tell me the syntax on OR?

I tried the below statements but it did not work.

<?count(PaymentStatus[Code='ISSUED'||Code='FORMATTED'])?>

Re: How to count non blank fields in Infopath forms?

B1rds — Mon, 09 May 2011 16:03:50 GMT

Hi Jimmy,

I have a similar but slightly different probem I have a Group and I have a subset of yes/No fields within that group. My probem long term is that I will have 10 groups and each group will have 5 fields and I want to find a way to count the fields via the group. Hope this makes sense

Thanks

Mike

Re: How to count non blank fields in Infopath forms?

benjaminlhlim — Mon, 12 Jul 2010 13:30:33 GMT

Thanks Jimmy for the quick answer, it works

Re: How to count non blank fields in Infopath forms?

Jimmy — Mon, 12 Jul 2010 11:54:44 GMT

count((field1 | field2 | field3 | ...)[. != ''])

If the fields are in a repeating structure:

count(repeatingField[fieldToCount != ''])

How to count non blank fields in Infopath forms?

benjaminlhlim — Mon, 12 Jul 2010 11:26:02 GMT

Hi,

I have 7 individual fields for keeping track of different rates which will only take values from 1 to 5, I need to sum up the 7 fields and to find the average, the challenge is that not all fields are fill up, therefore I need to know how many fields are not blank, I tried to create a new group and moved all the above 7 fields under this new group and used the Count function but it returns "1" which is not correct. I tried Count (field 1) + .... for seven times but this returns a fix value of 7.

Appreciate if you can assist me, thanks.