Forum Discussion
QuickBaseCoachD
8 years agoQrew Captain
Try this
Make a new formula numeric percentage field called [Yes %]
var number Yes = Count(
[Q1] = "Yes",
[Q2] = "Yes",
[Q3] = "Yes",
[Q4] = "Yes",
[Q5] = "Yes");
Do the same for the NOs.
Then
$Yes / ($Yes + $No)
Then set that field to show averages and not totals
Make a new formula numeric percentage field called [Yes %]
var number Yes = Count(
[Q1] = "Yes",
[Q2] = "Yes",
[Q3] = "Yes",
[Q4] = "Yes",
[Q5] = "Yes");
Do the same for the NOs.
Then
$Yes / ($Yes + $No)
Then set that field to show averages and not totals