average of the sum of a column

[Dcbrown428]

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?

 

[John Spencer]

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]

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.

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])

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?

 

[John Spencer]

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(...))

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.

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])

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?