# Total precentage in table reports

• 0
• Question
• Updated 3 years ago

I have a formula field that calculates a percentage from two fields. It does the job but it's messed up on a table report. For example, i have a customer that has 4 projects and one project is 14% done, second is 0%, third is 89% and the forth is 27% done. The totals in the table report then shows 131% and it should be 57%. The grand total calculates all of the percentages that go over 200% and still rising, while i would like to know only within 100%.

Is there a way to make the total calculate correctly? The report is grouped and sorted by the customer.

• 0 Points

Posted 3 years ago

• 0

QuickBaseCoach App Dev./Training, Champion

• 65,806 Points
It sounds like you want to show the Average and not the Total, so change the field properties of that [% completed] field to show Averages and not Totals.  However, I am not understanding how you get to 57%.    It that supposed to be the Average of 14%, 0%, 89%, 27% .  On my calculator that is an Average of 32%
• 0 Points
The 57% is my miscalculation. Will try the AVG option and let you know. Thanks!