5 Replies Latest reply on Aug 11, 2009 3:46 PM by comment_1

    Calculating Percentages on Sub-Summaries



      Calculating Percentages on Sub-Summaries


      On my check register, each check (each record) has fields for Discounts_Owed and Discounts_Taken.  In a calculation field Percent_Earned I have what percentage I achieved Discounts_Taken divided by Discounts_Owed. 


      At the end of the check register I sum both fields:

      Discounts_Owed_sum (summary field)

      Discounts_Taken_sum (summary field)


      I have a calculation field for the percentage earned overall:  Discounts_Taken_sum divided by Discounts_Owed_sum.  I have this set for unsaved (calculate as needed). 


      However, when I select my found set, the "summary" field is the same all the way down the report.