AnsweredAssumed Answered

Calculating Percentages on Sub-Summaries

Question asked by TKnTexas on Aug 11, 2009
Latest reply on Aug 11, 2009 by comment_1

Title

Calculating Percentages on Sub-Summaries

Post

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.

Outcomes