When picking fields for calculations, the selections do not show in the box once I hit ok

[chrissy_8224]

I have tried shutting down to restart and the spacebar ideas. 

[creative explorer]

@chrissy_8224 I think it may be the text fields aren't named in a way that Acrobat can recognize for calculations. To fix this, go back and rename the text fields. Simply click on each field, find its properties, and give it a simple, unique name without any spaces or special characters, like "Score_1," "Score_2," and so on. This will allow Acrobat to "see" and use them in your calculations properly. Once you've renamed them, the selected fields should appear correctly after you hit "OK."

[chrissy_8224]

I updated the field names to be Score_1....but didn't resolve the issue. 

I have another form that I used this feature for and didn't have a problem but this new form is giving me issues. I tried comparing all settings in the working form to this form and everything appears to be the same. 

[chrissy_8224]

I changed this to your suggestion but still didn’t pick the fields.

Chrissy

[try67]

You didn't rename the first field. Also, you didn't tick the option to commit the selected value immediately for each drop-down, which causes a delay in the average being calculated. I fixed both issues for you in the attached version.

[chrissy_8224]

Thank you! I tried what you suggested and it still doesn't add the fields when I pick them. Starting to think it is something in the program if others are able to but I am not. 

[Nesa Nurani]

It worked for me:

You can try to use custom calculation instead, but first rename field Score.1 to Score_1 then use this as custom calculation script:

var count = 0;
var avg = 0;

for(var i=1; i<=10; i++){
 var f = this.getField("Score_"+i).valueAsString;
 if(f != "Select"){
  count++;
  avg += Number(f);}}
if( count == 0)
 event.value = "";
else
 event.value = avg/count;

Also you may want to check 'Commit selected value immediately' in all of score fields so you don't need to lose focus on the field (click outside field) for score to calculate, it's under 'Options' tab.