Take total of a field and use it for percentage

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress

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 do that for all table. After that, I want to take percentage of them without NA i.e.

 (total yes) / (total yes+ total no) and
 (total no) / (total yes+ total no) 

Then, I would like to have their graph as total yes-total no-total NA and percentage yes and no. 

How can I do this?

Photo of Selin Biyik

Selin Biyik

  • 100 Points 100 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,758 Points 20k badge 2x thumb
Ideally all of these questions and answers would be child records (which provides much better reporting capabilities), but seeing as you just have the fields...

You will want to make 3 formula fields; # of Yes, # of No, # of N/A.

If the formula you use will be something to the affect of:
If([Question 1]="Yes", 1, 0),
If([Question 2]="Yes", 1, 0),
If([Question 3]="Yes", 1, 0)

Repeat for all questions, then you can copy it and change the "Yes" to "No" and "N/A".

Now you will have numeric values that you can graph or count for your averages and totals.
Photo of Selin Biyik

Selin Biyik

  • 100 Points 100 badge 2x thumb
Thank you. I have already this formula, but this works for only one entry. What I want is sum all "Yes" answers from all entries in other words reaching total as can be found below.

Is there a way to reach these values? 
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.


$Yes / ($Yes + $No)

Then set that field to show averages and not totals