Calculations on Report

  • Thread starter Thread starter Amanda
  • Start date Start date
A

Amanda

Hello,

I am working on a report. I want to make a calculation
based on another calculation in the report. For example I
have the average amount of money made per phone call. I
want to find out how many phone calls need to be made to
achieve a certain goal.

Any idea how to use a report field calculation in another
calculation?

Amanda
 
Put the following in the Control Source of a new control
on your report.

=([GoalAmount]/[AmtPerCall])

Charlie O'Neill
 
Back
Top