6 Replies Latest reply on Mar 3, 2009 8:26 PM by deliciousapple

    Sub-Summary in calculations



      Sub-Summary in calculations


      I need to calculate closing percentages in summary rows.


      I have been able to use the getsummary function and calculate a closing percentage for all records showing in a report.   I would like to do this for summary rows as well.



      If I have 45 records showing in a report, I might have it broke down into three cities, (sub-summaries)

      Seattle has 20 appointments, 5 sales

      Lacey has 15 appointments, 2 sales

      Olympia has 10 appointments, 3 sales 


      How do I get a simple close percentage per city? example i would want to see a field that says 25% for seattle

      I have the total close percentage for all records showing on the report, in this example I would see a 22.22% closing percentage on all appointments. 


      My summary field for total appointments is "count_date"

      My summary field for sales is "count_sale_gross"