Skip to main content
Anonymous
January 22, 2019
Answered

Need javascript to calculate a percentage

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 is closed to new replies. Start a new post to keep the conversation going.
try67
try67Correct 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;
View reply

4 replies

Anonymous
January 22, 2019

Translate
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;
Translate
Anonymous
January 22, 2019

You are a lifesaver!! Thank you so much!

Translate
try67
Community Expert
try67Community Expert
Community Expert
January 22, 2019

What are the names of the fields involved?

Translate
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices