Is there a way to get a percentage based on a field of checkboxes? I want to try to put a percentage on a ticket based on how many TRUE hits there are.

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

I have a section of a report I am working on that will have 10-15 checkboxes (or Yes/No options).  The client wants a percentage showing how many checks, or YES hits there are.  Is there a way to do this or will I have to use a numeric field to record the initial data?

Photo of Matt

Matt

  • 0 Points

Posted 4 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
You can make a field which calculates the % of yes checkboxes on a ticket to get that Ticket's score.  Set the field's Properties to show averages but not totals.


count(

[checkbox 1],[checkbox 2] ....[checkbox 15])/15



On any table, it will show the Average, or you can also do a Summary Report showing an Average.