cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
Choose Language Hide Translation Bar
Steve_Kim
Level IV

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 IV

Re: JMP formula : Missing value

Yeah!!!! Thank you so much PMroz.

have a nice day!!   ^__^)/