Getting field value 0 if the calue is grater than 0

Question

var J = Number(this.getField("V10").valueAsString);
var K = eval(this.getField("F10").valueAsString);
var d = Number(this.getField("H1").valueAsString);
var e = this.getField("D10").valueAsString;
var f = Number(this.getField("I1").valueAsString);

event.value = "";

if (e !== "") {
e = Number(e);
if (e === 0) {
event.value = "<LOD";
} else {
var total;
if (J !== 0 && f !== 0) {
total = (K * d) / (J * f);
event.value = total.toFixed(3);
}
}
}

Hi,

in above script when I write 0/100 in K, the value appearing correct in E. But when I write 1/100 is F. Attached pdf link for file.

Lab. 2.29.24_2 updated.pdf

Nesa Nurani · Accepted Answer

I need the cell shows value. Is there any option we can achieve that?Use another condition:if (J == 0 && f == 0) {total = (K * d);  ?

try67 · Answer

J7 is zero so the result of this formula is invalid (since division by zero is not allowed):total = (K * d) / (J * f);

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.