2 Replies Latest reply on May 9, 2012 11:01 AM by ScottKissel

    calculation using summary fields in a report

    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?