Re: average of radio boxes - non repeating table

davidair — Mon, 30 Jul 2007 17:22:53 GMT

The avg() built-in InfoPath function takes a nodeset as an argument, that is, an xpath that evaluates to one or more nodes.

For example, if you have a repeating value /my:myFields/my:group1/my:group2/field1 (where group2 is repeating) then a xdMath:Avg(/my:myFields/my:group1/my:group2/field1) will return the average of values of each instance of group2/field1.

Your case is not different but you need to construct a nodeset based on your non-repeating nodes. This can be done by using the xpath OR operator |. For example, if your fields are called field1, field2 and field3, the formula to use will be:

xdMath:Avg(my:field1 | my:field2 | my:field3)

average of radio boxes - non repeating table

robbieswife2b — Mon, 30 Jul 2007 14:32:01 GMT

I have part of my form which has 6 radio boxes on it (not in a repeating table) and I would like to have a field which will take the average of those 5 boxes - can I do this?

Many thanks

General

Re: average of radio boxes - non repeating table

average of radio boxes - non repeating table