JMP formula : Missing value

[#1]

JMP formula : Missing value

Hi there~ ^^

Could you do me a favor?

Do you have any idea with this? I think this is a simple question, but I dont know yet.

I want to select "Missing continous value" in formula.

I wanna change missing continous values to "Unknow" with character value.

[#2 · Accepted solution]

Use the "IS MISSING()" function:

The JSL code looks like this:

If (:Thickness <= 0.15, "Under 0.15",

    :Thickness > 0.15, "Over 0.15",

    Is Missing( :Thickness ), "Unknown"

)

[#3]

Yeah!!!! Thank you so much PMroz.

have a nice day!!   ^__^)/