cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
Steve_Kim
Level III

JMP formula : Missing value

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
pmroz
Super User

Re: JMP formula : Missing value

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"

)

View solution in original post

2 REPLIES 2
pmroz
Super User

Re: JMP formula : Missing value

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"

)

Steve_Kim
Level III

Re: JMP formula : Missing value

Yeah!!!! Thank you so much PMroz.

have a nice day!!   ^__^)/