Can't Get Calculated Field To Display Blank When A Related Field Is Left Blank

Need to display a blank unless v1 has a number entered. Currently v1 shows -30 with nothing entered. Please help. Thanks.

This topic has been closed for replies.

Correct answer try67

Try this:

var s1 = this.getField("AsFoundRow1").valueAsString;
if (s1=="") event.value = "";
else {
	var v1 = Number(s1);
	// rest of code goes here
}

Correct answer

Community Expert

Try this:

var s1 = this.getField("AsFoundRow1").valueAsString;
if (s1=="") event.value = "";
else {
	var v1 = Number(s1);
	// rest of code goes here
}

Inspiring

Wow! Fast response and works perfectly. Learned something new today. Thank you try67.

Sign up