Crystal Reports - Average of two fields

  • Thread starter Thread starter amit
  • Start date Start date
A

amit

Hi guys

I am using access database with Crystal Reports in VS2003
I am working on "Hospital Database"
The fields are -
Name - Date - ConsultingCharge - TotalFees
i.e. Total Fees include fees for medicine issued by hospital

In the report I want to display the Average of ConsultingCharge and
TotalFees for every record.
i.e. Name - Date - ConsultingCharge - TotalFees - Aversge (TotalFees/
ConsultingCharge)
How can we display the average of two fields in database for every
record.

Further in the monthly analysis report I want to display
Month - TotalFees - ConsultingCharge - Average ( ConsultingCharge/
TotalFees )
How to generate report for month from the database with all the dates.
How to display the average of sum of ConsultingCharge and TotalFees.

Thanks

Amit
 
You will need to create a formula to do this.
In Crystal Reports, create a new formula called something like AverageFees,
inside the editor create TotalFees/ConsultingCharges and save it.
Add the formula (AverageFees) to the report where you want it displayed.

CM
 
Back
Top