If GTE is a total and CAE us a variable. What is the script for BDC if BDC = CAE-GTE if CAEGTE or blank if CAE = 0 or is blank? A second script BDE where BDE=GTE-CAE if GTECAE or blank if CAEGTE?

Question

If GTE is a total and CAE us a variable.  What is the script for BDC if BDC = CAE-GTE if CAE>GTE or blank if CAE = 0 or is blank? A second script BDE where BDE=GTE-CAE if GTE>CAE or blank if CAE>GTE?

George_Johnson · Accepted Answer

They are names of fields (cash advanced to employee, grand total expenses - the other fields are BDC balance due company and BDE balance due employee).

OK, the custom calculation script of the BDC field could be something like:

(function () {

// Get the input field values, as numbers

var CAE = +getField("CAE").value;

var GTE = +getField("GTE").value;

// Set this field's value

event.value = CAE > GTE ? CAE - GTE : "";

})();

That final line of code is equivalent to the following if/else statement:

if (CAE > GTE) {

event.value = CAE - GTE;

} else {

event.value = "";

}

This should help you figure out the other calculation script, but if you get stuck, post again.

gkaiseril · Answer

Have you looked a the JavaScript Reference Provided by MDN?Look under Statements and Expressions and Operators.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded