AVERAGE

[dwalsh77]

How would I get the average of 5 fields (Field1 - Field 5)?
And is it possible to leave specific fields out of the calculation if they
are left blank)

Thanks

 

[dwalsh77]

Just another little piece of info.

From what I have been reading on doing averages in Infopath, it seems that
you have to use a Repeating Table or something similar. I would like to avoid
that if possible.

Basically, I have 5 standard questions on a form, where the user enters 1 -
5 for each question. The fields to enter the numbers are simply Field1 -
Field5. Then I would like to get the average? And if possible, can the
formula exclude any fields that are left blank so as not to include them in
the average funtion?

Thanks