Skip to main content
January 22, 2019
Answered

Need javascript to calculate a percentage

  • January 22, 2019
  • 2 replies
  • 956 views

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?

This topic has been closed for replies.
Correct answer try67

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;

2 replies

January 22, 2019

try67
Community Expert
try67Community ExpertCorrect answer
Community Expert
January 22, 2019

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;

January 22, 2019

You are a lifesaver!! Thank you so much!

try67
Community Expert
Community Expert
January 22, 2019

What are the names of the fields involved?