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

[Charles May]

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
"amit" <am***********@gmail.comwrote in message
news:11**********************@k70g2000cwa.googlegr oups.com...

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