I need to summarize the % for a row and the column, how can I do that?

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

I created a summary report to show the number of contracts tested and how many of those records passed. These are sorted by group but the Custom column I created to show % isn't working. How do I get this data to show in this report?

Photo of Niki

Niki

  • 0 Points

Posted 4 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,168 Points 50k badge 2x thumb
For a summary report and because you are "weighting" each Contract equally (not by value) you can create a formula numeric percentage field which will be like

IF([Pass/Fail]="Pass",1,0). 


The on the summary report include that field but set it to show Averages and not Totals in the Summary report settings.
Photo of Niki

Niki

  • 0 Points
If I need to "weigh" them for a % how would I do that?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,168 Points 50k badge 2x thumb
Well tell me what are you are Grouping your Contracts by on the Summary report and I can answer.  Are they summarized by date like by week or month?