Need help writing javascript

Question

I need help writing javascript where I am dividing 2 fields and the answer is in a percentage. I keep getting an error message and I know it is because I need to add javascript telling what to do when the answer is zero, but I am unsure how to do that. This is what I currently have written in the Calculate tab under custom calculation script:

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!!!

try67 · Answer

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;

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.

Scanning file for viruses.

This file cannot be downloaded