Skip to main content
P
Parreshea5ED2
Participant
December 28, 2020
Answered

Field Not Calculation Correctly

  • December 28, 2020
  • 1 reply
  • 617 views

I am using the scripture below to add 4 fields and to be blank if the value is zero

var b=this.getField("BonusPY");

var c=this.getField("InterestPY");

var d=this.getField("OtherIncPY");

var e=this.getField("SalaryPY");

event.value=(b.value+c.value+d.value+e.value);

if(event.value == 0) event.value = "";

 

But everytime I test it adds incorrect at first and then correct when I enter the last number. For instance, if I input 1, 1, 1, and 1 it will calculate 1 + 1 = 11 then +1 = 21  then + 1 = 4.

What am I doing wrong? Please help.

 

This topic has been closed for replies.
Correct answer Nesa Nurani

See if this works for you:

var b=Number(this.getField("BonusPY").value);

var c=Number(this.getField("InterestPY").value);

var d=Number(this.getField("OtherIncPY").value);

var e=Number(this.getField("SalaryPY").value);

event.value=(b+c+d+e);

if(event.value == 0) event.value = "";

1 reply

Nesa Nurani
Community Expert
Nesa NuraniCommunity ExpertCorrect answer
Community Expert
December 28, 2020

See if this works for you:

var b=Number(this.getField("BonusPY").value);

var c=Number(this.getField("InterestPY").value);

var d=Number(this.getField("OtherIncPY").value);

var e=Number(this.getField("SalaryPY").value);

event.value=(b+c+d+e);

if(event.value == 0) event.value = "";
    P
    Parreshea5ED2Author
    Participant
    December 30, 2020

    Thanks you so very much this worked perfectly.

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