empty field blows up calculations

OK, so, let's first dig up some math skills: What happens when you divide a value by zero? Yep, the result is + or - Infinity (not beyond here…). What happens when you divide zero by zero? Yep, the result is undefined.

With that, we have the cause of the problem; division by zero. What to do when we program such a formula?

That means working a bit on Acrobat Forms and JavaScript skills…

Let's assume that your table is set up so that the name of each field in a row ends with the row number. Let's also assume that you have 8 rows in the table. Finally, let's assume that the Percentage field is formatted as Percentage.

It is considered Best Practice to consolidate all scripts into one single script, and to add it to the Calculate event of a hidden, readonly field, which is otherwise not involved in any way with the rest of the form.

The segment of the script which does the percentage calculation may then look like this:

for (var i = 1 ; i <= 8 ; i++) {

if (this.getField("CumulativeAmount" + i).value != this.getField("CumulativeAmount" + i).defaultValue && this.getField("Budget" +i).value != this.getField("Budget" + i).defaultValue) {

this.getField("Percentage" + i).value = this.getField("CumulativeAmount" + i).value*1 / this.getField("Budget" + i).value*1 ;

}

}

And that should do it (note that the script has 5 lines in total; one or two lines may break).

Hope this can help.