Getting field value 0 if the calue is grater than 0

[Bhuwesh]

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

[try67]

J7 is zero so the result of this formula is invalid (since division by zero is not allowed):

total = (K * d) / (J * f);

[Bhuwesh]

can you tell me correct script to get the result. 

[try67]

What is the desired result in case J or F are zero?

[Bhuwesh]

I require the calculation to produce a valid result even if the values of J and f are 0. The calculation should utilize the available fields to generate a meaningful outcome, rather than yielding an invalid result. Considering them as 1 might suffice, but I'm uncertain. I'm open to any solution that ensures the calculation behaves appropriately.

[try67]

There is no valid result in this scenario. The field should remain empty, in my opinion.

[Bhuwesh]

I need the cell shows value. Is there any option we can achieve that?

[Nesa Nurani · Accepted solution]

Use another condition:

if (J == 0 && f == 0) {
total = (K * d);  ?

[Bhuwesh]

Thanks it worked when I add this condition too with considering blank value as 1

[Bhuwesh]

I used this 

var J = Number(this.getField("V1").valueAsString);
var K = eval(this.getField("F1").valueAsString);
var d = Number(this.getField("H1").valueAsString);
var e = this.getField("D1").valueAsString;
var f = Number(this.getField("I1").valueAsString);

event.value = "";

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

[try67]

What value, exactly?