Tallying radio button values

[slaron]

Is there any way to make all the radio button values tally? For some reason I can't get the last choice to be included in the total.

I have created a form that has 6 questions. Each question has 5 answer options. Each option has a different value. I need the option values to fill-in in a separate portion of the form (based on end users answer) and then total automatically. 

To do this, I have created 6 groups of radio buttons (3A1, 3A2, 3A3, 3A4, 3A5, 3A6) with different values (choices). In the portion of the form where the values are to appear and calculate, I have created 7 text fields (6 for the corresponding answer value and 1 for the total). The 6 answer values appear when the radio button is selected, but the calculation for the total doesn't begin until the 2nd radio button is chosen and only includes the 1st radio button value.

When all selections are made, the total is not correct because it does not include the last choice. And,if you make another selection, the previous answer value is calculated, not the new selection value. I am currently using the calculation sum option for the total score with the text fields (3A 1 Score, 3A 2 Score, 3A 3 Score, 3A 4 Score, 3A 5 Score, 3A 6 Score) picked.

[try67]

Sounds like a problem with the field calculation order (NOT the tab order).

[slaron]

It doesn't matter what order you select the answers, it just doesn't ever calculate the last choice. I have played with adding a check box with the value=0 and adding it to the calculation. That works, as long as you always check it when you are done making (or changing) your selections, but it's not really a good solution. It just proves that you need to make another selection for the last selection to be included in the calculation.

[try67 · Accepted solution]

The order in which you select the answers doesn't matter. What matters is the internal order in which the fields are being calculated.

You need to make sure that the total field is calculated after the other fields for it to work correctly.

[slaron]

The total field is calculated after the other fields. All the fields are calculating, EXCEPT the last selection. It's as if you need to hit an enter button.

[try67]

Based on what are you saying that? Did you check the field calculation order?

[slaron]

The total field calculation was done using the calculation tab (Value is Sum). The calculation is listed as: 3A 1 Score, 3A 2 Score, 3A 3 Score, 3A 4 Score, 3A 5 Score, 3A 6 Score, 3A T Score.

[try67]

That's good, but still irrelevant to the calculation order. What version of Acrobat do you have?

[slaron]

Acrobat X Pro. How do you check the calculation order?

[try67]

In Form Edit mode (Tools - Forms - Edit), under Tasks, click on Other Tasks and then Set Field Calculation Order.

[slaron]

Thank you! All set.