Subscribe Bookmark RSS Feed

JMP formula : Missing value

jameskim

Community Trekker

Joined:

May 17, 2012

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.

3865_Missing value.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

Use the "IS MISSING()" function:

3867_Is Missing.png

The JSL code looks like this:

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

    :Thickness > 0.15, "Over 0.15",

    Is Missing( :Thickness ), "Unknown"

)

2 REPLIES
Solution

Use the "IS MISSING()" function:

3867_Is Missing.png

The JSL code looks like this:

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

    :Thickness > 0.15, "Over 0.15",

    Is Missing( :Thickness ), "Unknown"

)

jameskim

Community Trekker

Joined:

May 17, 2012

Yeah!!!! Thank you so much PMroz.

have a nice day!!   ^__^)/