calculating averages

K

KC

In a report, i have a total count of number of referrals
according to "Intake Date". So let's say for the month of
August, there were 21 working days. within those 21
days,there were 195 referrals. How do i come up with a
daily average on the report that will tell me the average
number of referrals per day?
 
A

AJ Raiber

In an unbound text block type the following formula
=[#Referrals]/[#WorkingDays]. Obviously the field names
(Enclosed in square brackets[]) will need to be whatever
you have named the field. If there is no field and they
themselves are formulas in text boxes, simply replace the
appropriate formula into the space showing the filed name
above.

HTH.

AJ
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top