event.value = this.getField("Division 1 - 1").value / this.getField("Grand Total 1").value
and in the Format tab I have the category set to percentage.
The error I get is "The value does not match the format of the field"
Any help is much appreciated! Thank you!!!
This issue was discussed here many times in the past... Basically this error happens when the divisor is zero, which is an illegal operation.
To prevent it you can do something like this:
var a = Number(this.getField("Division 1 - 1").value); var b = Number(this.getField("Grand Total 1").value); if (b==0) event.value = ""; else event.value = a/b;
Thank you. I have seen this question several times and tried to break down the answers to work for me, but I am not familiar with java script at all and was having a hard time. I appreciate your help.