Average of a group of fields too

[Rob]

I cannot figure out how to get Infopath to calculate the average of many
fields in the same row of a table and also the average of many fields in many
rows of a table (repeating and non-repeating tables)

I can get it to sum the fields but whenever I try to implement an average
function by using the function box in the "Test Properties Box", I cannot get
it to work.

I am not a scripting/coding person so if that is the case, I would also need
help on how to incorporate the script solution. I hope the solution is just a
formula.

Please help. Thanks in advance

Rob

 

[Franck Dauché]

Hi Rob,

You could do this by scripting using xdExtension. If you do a search on
"xdExtension" in this forum there are great posts from Scott Heim and Greg
Collins about this (with step by step procedures).

Hope that it helps.

Regards,

Franck Dauché