Skip to main content
Participant
June 10, 2024
Answered

Sum Selected Radio Button Values in Total Field

  • June 10, 2024
  • 3 replies
  • 1184 views

I'm fairly new to creating "complex" fillable PDFs and am struggling with a basic sum formula. Any ideas?

 

Here's the overview:

There are 6 questions (and therefore 6 radio button groups) - I'm trying to sum the radio button selection for each of the questions in my TOTAL SCORE field. When I go to the calculate tab "Value is the SUM (+) of the following fields:" it does not have the option to add any of my radio buttons or groups. Is there a better, or 'standard' way of doing this? 

 

Here is how my questions are set up:

  • RTQ - Question 1
    • 18
    • 12
    • 6
    • 0
  • RTQ - Question 2
    • 0
    • 8
    • 12
    • 18
  • RTQ - Question 3
    • 0
    • 5
    • 10
    • 15
  • RTQ - Question 4
    • 15
    • 10
    • 5
    • 0
  • RTQ - Question 5
    • 19
    • 12
    • 7
    • 0
  • RTQ - Question 6
    • 15
    • 8
    • 0
  • TOTAL SCORE
This topic has been closed for replies.
Correct answer try67

Yes, that would do it. In the future, do not tick the box that says "This document requires signatures" when creating the form, as that converts the file to an Adobe Sign form, which has limited functionality compared to a "normal" PDF form.

3 replies

breannewAuthor
Participant
June 11, 2024

Update: I figured it out - originally the form was prepared for e-sign. I removed e-sign options to do the calculations and kept editing. All I had to do was close the program and reopen it. The more you know!

try67
Community Expert
try67Community ExpertCorrect answer
Community Expert
June 11, 2024

Yes, that would do it. In the future, do not tick the box that says "This document requires signatures" when creating the form, as that converts the file to an Adobe Sign form, which has limited functionality compared to a "normal" PDF form.

Nesa Nurani
Community Expert
Community Expert
June 11, 2024

The built-in options should work, but in case it doesn't for some reason, you can use this custom calculation script:

var total = 0;
for (var i=1; i<=6; i++){
var f = this.getField("RTQ - Question "+i).valueAsString;
if(f !== "Off")
total += Number(f);}
event.value = total;

 

try67
Community Expert
Community Expert
June 11, 2024

They should be there. What do you see in the Fields Selection dialog?

And yes, there are other ways of doing it, but the SUM command should work for you...