AVERAGE

D

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
 
D

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
 
Top