Copy link to clipboard
Copied
Hi,
I have a simple form with some radio buttons, and I'd like to create a formula to extract the values of the radio buttons and add them and/or average them. I've attached a picture of the document I'm working on. Keep in mind I'm a complete novice I'm just trying to learn some new skills.
If you apply the values as the "radio button choice" value of each field (under Properties - Options) then you'll be able to use the built-in calculation commands to do these operations.
Copy link to clipboard
Copied
If you apply the values as the "radio button choice" value of each field (under Properties - Options) then you'll be able to use the built-in calculation commands to do these operations.
Copy link to clipboard
Copied
Where would these built-in calculations be displayed? or how do I make them displayed?
I've set the value as a numeric value I just don't know how to get the sum of the values selected.
Copy link to clipboard
Copied
Where the result would be displayed? I had assumed you created a text field for it... If not then you should, and you'll find the calculation options under its Properties - Calculate tab.
Copy link to clipboard
Copied
Yes I just did that. One last thing I'd like to know, I've done a google search and still a little confused. How can I get:
(sum of values)/91
Copy link to clipboard
Copied
Let's say the fields are called Radio1, Radio2, Radio3, etc.
Under the "simplified field notation" option in the Calculate tab enter:
(Radio1 + Radio2 + Radio3) / 91
Copy link to clipboard
Copied
This got me where I needed to be with my form. Thanks so much for the help!!!