2 Replies Latest reply on Oct 25, 2016 1:52 PM by jessicam63354393

Need help writing javascript

jessicam63354393 Oct 24, 2016 2:43 PM

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

1. Re: Need help writing javascript

try67 Oct 25, 2016 12:41 AM (in response to jessicam63354393)
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;
Like Show 0 Likes(0)

Actions
2. Re: Need help writing javascript

jessicam63354393 Oct 25, 2016 1:52 PM (in response to try67)

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.
Like Show 0 Likes(0)

Actions

Go to original post

Incoming Links

Re: What are the rules for using a "simplified field notation" calculation formula fillable

Legend

Correct Answers - 10 points