Summary Report

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
I have a summary report with a column of late loads per carrier and another with total loads per carrier. I want a 3rd column in % of late loads, Late loads/total loads?
Photo of Ronal Alemancampos

Ronal Alemancampos

  • 70 Points

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
In the summary settings you can check a box to define a calculated column.

Then just format it how you'd like, and insert the formula.

Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,824 Points 50k badge 2x thumb
You may find that you need to create a formula field called Late Loads %. Have it calculate to 1 if late and zero if not late. Format it as a Percentage

Then put that in your report and set the Summy to Summarize Averages.