I am trying to add a column to the attached summary table that will show the % of inspections an operator is having compared to total inspections being done.
# of inspections / Total inspections
Since I do not have a field for Total inspections I am not sure how to accomplish this. Is there a way to incorporate Quickbases Total field into a formula?
 876 Points
Posted 3 years ago
QuickBaseCoach App Dev./Training, Champion
 62,520 Points
For example,
You make a new table called called Inspections Totals and make exactly 1 record in it. It will be record ID#1. Then on the Inspectors Records, you make a field called [Link to Summary Totals] as a numericformula field with a formula of 1.
The make a Relationship where 1 Summary Totals record is related to many (in fact all) Inspectors records. Then do a summary total on that Relationships on Total Inspections. I assume that you might have different Summary totals fields on the Inspectors table for different time periods such as Last Month, This Month To Date, this YTD etc. So there would also be different Summary fields on the Summary table.
Then do a lookup back down to the Inspectors table and you will be able to get your calculation of the % of inspection that a particular Inspector has done.
QuickBaseCoach App Dev./Training, Champion
 62,520 Points
 590 Points
QuickBaseCoach App Dev./Training, Champion
 62,520 Points
QuickBaseCoach App Dev./Training, Champion
 62,520 Points
Sorry I just realized that for your situation there is a way way easier solution.
Just make a formula numeric percentage field the formula like
IF([Win] = true, 1,0)
Then add that field to your summary report and set it to show as an average.
QuickBaseCoach App Dev./Training, Champion
 62,520 Points
Sorry I just realized that for your situation there is a way way easier solution.
Just make a formula numeric percentage field the formula like
IF([Win] = true, 1,0)
Then add that field to your summary report and set it to show as an average.
Related Categories

Formulas & functions
 2883 Conversations
 72 Followers

Reports & charts
 3059 Conversations
 87 Followers

Tables & fields
 7165 Conversations
 170 Followers