Total precentage in table reports

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

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. 

Photo of Igor

Igor

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,806 Points 50k badge 2x thumb
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%
Photo of Igor

Igor

  • 0 Points
The 57% is my miscalculation. Will try the AVG option and let you know. Thanks!