SUM radio button values

[josem53290896]

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.

[try67 · Accepted solution]

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.

[josem53290896]

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.

[try67]

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.

[josem53290896]

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

[try67]

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

[Saint_Jude_Lost_Coz]

This got me where I needed to be with my form. Thanks so much for the help!!!