average of the sum of a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field in a report that gives me the number of days from a certain
date for each item. I need to get an average of the total for this field.
What would you recommend?
 
In the group or report footer, in a control repeat the calculation you
currently are using but surround it with Avg()

For example, you might have

=Avg(Date()-[DateOfService])
 
That worked. Can you tell what I need to do to make the answer round to the
nearest whoole number? I have the decimal point set at zero, but it doesn't
change it.

John Spencer said:
In the group or report footer, in a control repeat the calculation you
currently are using but surround it with Avg()

For example, you might have

=Avg(Date()-[DateOfService])


Dcbrown428 said:
I have a field in a report that gives me the number of days from a certain
date for each item. I need to get an average of the total for this field.
What would you recommend?
Click to expand...
Click to expand...
 
Post your expression.

If setting the decimal point to zero is not working, there is the
possibility that the control does not recognize the value as a number.

Try
=Val(Avg(...))
or
=CDbl(Avg(...))
Dcbrown428 said:
That worked. Can you tell what I need to do to make the answer round to
the
nearest whoole number? I have the decimal point set at zero, but it
doesn't
change it.

John Spencer said:
In the group or report footer, in a control repeat the calculation you
currently are using but surround it with Avg()

For example, you might have

=Avg(Date()-[DateOfService])


Dcbrown428 said:
I have a field in a report that gives me the number of days from a
certain
date for each item. I need to get an average of the total for this
field.
What would you recommend?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top