# Take total of a field and use it for percentage

• 0
• Question
• Updated 2 years ago
• In Progress
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 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?

Thanks
• 100 Points Posted 2 years ago

• 0
• 31,758 Points 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:
Sum(
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.
• 100 Points 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?
• 75,144 Points 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