Forum Discussion

SelinBiyik's avatar
SelinBiyik
Qrew Member
8 years ago

Take total of a field and use it for percentage

Hi, I have a table which consists of questions whose answers are only Yes/No/NA. I would like to see total number of Yes,No and NA for all questions. I can sum them for only one row, but I want to ...
App builders
Forms
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
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