AnsweredAssumed Answered

calculation using summary fields in a report

Question asked by ScottKissel on May 9, 2012
Latest reply on May 9, 2012 by ScottKissel

Title

calculation using summary fields in a report

Post

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?

Outcomes