Copy link to clipboard
Copied
Any help would be greatly appreciated. I need a java script to get the percentage of 2 numbers. I am including a picture below. For example, I need the number for Conventional Conforming divided by the Total to get the percentage used. Can anyone help?
Sorry, didn't realize they were the same fields...
You can use this code as the custom calculation script of the percentage field, then:
var v1 = Number(this.getField("1cc").valueAsString);
var v2 = Number(this.getField("totalvolume").valueAsString);
if (v2==0) event.value = "";
else event.value = v1/v2;
Copy link to clipboard
Copied
What are the names of the fields involved?
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Sorry, didn't realize they were the same fields...
You can use this code as the custom calculation script of the percentage field, then:
var v1 = Number(this.getField("1cc").valueAsString);
var v2 = Number(this.getField("totalvolume").valueAsString);
if (v2==0) event.value = "";
else event.value = v1/v2;
Copy link to clipboard
Copied
You are a lifesaver!! Thank you so much!