Calculate the Average of Selected Dropdown Fields Excluding Fields Not Yet Selected

Question

Hey folks,

I have an evaluation form that is pretty straightforward, in which an evaluator determines a score of 13 criteria by selecting a value of 1-10 in a dropdown. The dropdown has a blank value (perhaps a single space?), then 1-10 as individual options. I have a text field that calucates the average of these scores through normal Acrobat functionality. The owner of the form, however, would like for the average to be calculated only by the specific dropdown boxes that have an actual selection. So, if the evaluator has only selected 8 values of the 13 possible, the average is calculated on those 8, rather than providing 5 false "zeros" into the calculation. I hope this makes sense.

The dropdowns are named sequentially (Score_1, Score_2, Score_3...).

My Javascript is not strong, and I'm not sure how best to code a solution. Any assistance would be appreciated.

Nesa Nurani · Accepted Answer

In dropdown fields properties under 'Option' tab, select 'Commit selected value immediately'.

Use this as 'Custom calculation script' of text field:

var total = 0;
var x = 0;
for(var i=1; i<=13; i++){
if(this.getField("Score_"+i).valueAsString != " "){
x++;
total += Number(this.getField("Score_"+i).value);}}
if(x == 0)
event.value = "";
else
event.value = total/x;

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.