Have a client that I have built a simple form for that does basic calculations. There are 6 drop downs that all contain N/A, 1, 2, 3. And at the end a overall average is calculated from these drop downs. client is wanting to totally ignore any drop downs that contain N/A meaning if N/A is in 2 of the 6 drop downs then a average should only be calculated on 4 drop downs. I am just lost on the logic or if statement needed to tell the total field to ignore a certain drop down field if user has selected N/A. Here is my code and is not working..Please suggest some ideas.
<html>
<head><script type="text/javascript">
var aFieldNames = new Array();
aFieldNames["N/A"]=0;
aFieldNames["1"]=1;
aFieldNames["2"]=2;
aFieldNames["3"]=3;
var nCount = 0;
var nSum = 0;
event.value = 0;
for(i = 0; i < aFieldNames.length; i++)
{
if(this.getField(aFieldNames[i]).valueAsString != "N/A")
{
nCount++;
nSum += parseFloat(this.getField(aFieldNames[i]).value);
}
}
if(nCount != 0)
{
event.getElementById("bpover").value = nSum / nCount;
}
</script>
</head>
<body>
<select name="Value[]" onChange="alert(this.value):">
<option name="N/A">N/A</option>
<option name="1">1</option>
<option name="2">2</option>
<option name="3">3</option>
</select><br>
<select name="Value[]" onChange="alert(this.value):">
<option name="N/A">N/A</option>
<option name="1">1</option>
<option name="2">2</option>
<option name="3">3</option>
</select><br>
<select name="Value[]" onChange="alert(this.value):">
<option name="N/A">N/A</option>
<option name="1">1</option>
<option name="2">2</option>
<option name="3">3</option>
</select><br>
<select name="Value[]" onChange="alert(this.value):">
<option name="N/A">N/A</option>
<option name="1">1</option>
<option name="2">2</option>
<option name="3">3</option>
</select><br>
<select name="Value[]" onChange="alert(this.value):">
<option name="N/A">N/A</option>
<option name="1">1</option>
<option name="2">2</option>
<option name="3">3</option>
</select><br>
<br>
avg <input type="text" name="Average" ID="bpover" readonly>
</body>
</html>
Here you go! @Shakti Phartiyal's answer has an explanation of the things that were wrong.
function calcAvg(){
//Get all elements with 'class="select"'
var selects = document.getElementsByClassName("select");
//Initialize vars
var avg = 0;
var count = 0;
//Calculate average
for(var i=0;i<selects.length;i++){
if(selects[i].value!="N/A"){
count++;
avg+=Number(selects[i].value);
//Alert for debugging purposes
//alert(selects[i].value+" "+avg);
}
}
avg=avg/count;
//Output average
document.getElementById("bpover").value=avg;
}
<select class="select" name="Value[]" onChange="calcAvg();">
<option name="N/A">N/A</option>
<option name="1">1</option>
<option name="2">2</option>
<option name="3">3</option>
</select><br>
<select class="select" name="Value[]" onChange="calcAvg();">
<option name="N/A">N/A</option>
<option name="1">1</option>
<option name="2">2</option>
<option name="3">3</option>
</select><br>
<select class="select" name="Value[]" onChange="calcAvg();">
<option name="N/A">N/A</option>
<option name="1">1</option>
<option name="2">2</option>
<option name="3">3</option>
</select><br>
<select class="select" name="Value[]" onChange="calcAvg();">
<option name="N/A">N/A</option>
<option name="1">1</option>
<option name="2">2</option>
<option name="3">3</option>
</select><br>
<select class="select" name="Value[]" onChange="calcAvg();">
<option name="N/A">N/A</option>
<option name="1">1</option>
<option name="2">2</option>
<option name="3">3</option>
</select><br>
<br>
avg <input type="text" name="Average" id="bpover" readonly>
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments