Crystal Reports - Average of two fields

[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

 

[Guest]

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.

Have you taken a look at formula fields?