Forum Discussion

StevenPearson's avatar
StevenPearson
Qrew Assistant Captain
6 years ago

Percentage based on checkbox

We have several offices and managers. Each office and manager are in charge of several trucks. I have a check box formula that basically says if truck check date is last month, true else false. I need to create a report that says, for each office/manager what percentage, for their area, of their trucks had a check done. Or checks=yes/number of trucks. The percent of column total doesn't work on the summary because I need the percentage based on trucks assigned to each office/manager, not the percentage of the column. Any ideas?
Formulas and functions
reports and charts
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    You should be able to make a formula numeric field set to display Percentage called with a formula of

    if(=true, 1,0)

    then use the average of that in the summary report.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    We can get away with that "trick" because a truck is a truck is a truck and they are all equally weighted.  So the Average of the 0% and the 100% records is mathematically correct.