The value entered does not match the format of the field.

[Oayusuf]

Hi, I keep getting this error whenever the ("A" + i) fields are all blank. Can someone  kindly help me refine the script to ensure that whenever ("A" + i) are all empty, this field should remain blank as well.

Thanks.

var sum = 0;
var sumText = 0; 
for (var i = 1; i < 150; i += 1) {

    if (getField("V" + i).value == "Yes") {sum += 1}
    if (this.getField("A" + i).value != "") {sumText += 1}


event.value = sum/sumText;
}

[Nesa Nurani · Accepted solution]

Try like this:

var sum = 0;
var sumText = 0;
for (var i = 1; i < 150; i += 1) {

if (getField("V" + i).value == "Yes") {sum += 1}
if (this.getField("A" + i).value != "") {sumText += 1}

if(sum == 0 || sumText == 0)
event.value = "";
else
event.value = sum/sumText;
}

[Oayusuf]

Thank you very much! This worked perfectly!