D
dwalsh77
I currently have 5 text boxes, each which allow the user to enter a value
between 1-5. I have already created an Expression Box which sums the text
boxes after the user enters his/her values (i.e. Field1 + Field2 + Field3 +
Field4 + Field5), and returns the answer on the form.
What I am attempting to do now is find a way to correctly obtain the AVERAGE
of the numbers after they have been added. So for example, if a user enter 3,
5, 2, 5, and 5 in the text boxes, then the average should be 4. As well, the
user does not have to enter values into all 5 text boxes, so if the user
decides to only fill in 3 of the 5 text boxes with numbers, then the average
should divide by 3, and not 5.
I tried the average function in an expression box, but it did not seem to
work.
Any help would be appreciated.
Thanks.
between 1-5. I have already created an Expression Box which sums the text
boxes after the user enters his/her values (i.e. Field1 + Field2 + Field3 +
Field4 + Field5), and returns the answer on the form.
What I am attempting to do now is find a way to correctly obtain the AVERAGE
of the numbers after they have been added. So for example, if a user enter 3,
5, 2, 5, and 5 in the text boxes, then the average should be 4. As well, the
user does not have to enter values into all 5 text boxes, so if the user
decides to only fill in 3 of the 5 text boxes with numbers, then the average
should divide by 3, and not 5.
I tried the average function in an expression box, but it did not seem to
work.
Any help would be appreciated.
Thanks.