calculation using summary fields in a report
Need help figuring this out using FM pro 11:
I have created a report. In the sub-summary part, I am sorting by a field named "referral source". This results in a report sorted by each referral source (TV commerical, radio ad, newspaper ad...). I included a summary field named "total calls" which shows the total calls received for each referral source as well as a summary field named "total sales" which shows the total sales for each referral source.
I would like to add another field which will divide "total sales" against "total calls" to show a "closing rate" for each referral source.
I would like the report to look similiar to MS excel:
referral source total calls total sales closing rate
TV commercial 4 2 50%
radio ad 10 8 80%
newspaper ad 5 1 20%
How is this field constructed?