Using Formulas and the Formula Editor

[#1]

See how to make and edit formulas in JMP

See how to use JMP's powerful, easy-to-use Formula Editor to create columns with values computed by a formula and store the formula as part of column information. Learn how to build formulas that are simple assignments of numeric, character or row state constants, or complex evaluations based on conditional clauses. See how formulas are linked to, or dependent on, values in other columns and how those values will be automatically recomputed when values change.

Formulas and Formula Editor

Video Player is loading.

Play Video

Play

Mute

Current Time 0:00

/

Duration 41:27

Loaded: 0.00%

00:00

Stream Type LIVE

Seek to live, currently behind liveLIVE

Remaining Time -41:27

1x

Playback Rate

Chapters

• Chapters

Descriptions

• descriptions off, selected

Captions

• captions settings, opens captions settings dialog
• captions off, selected

Audio Track

• en (Main), selected

Picture-in-PictureFullscreen

This is a modal window.

Beginning of dialog window. Escape will cancel and close the window.

Text

ColorWhiteBlackRedGreenBlueYellowMagentaCyanTransparencyOpaqueSemi-Transparent

Background

ColorBlackWhiteRedGreenBlueYellowMagentaCyanTransparencyOpaqueSemi-TransparentTransparent

Window

ColorBlackWhiteRedGreenBlueYellowMagentaCyanTransparencyTransparentSemi-TransparentOpaque

Font Size

50%75%100%125%150%175%200%300%400%

Text Edge Style

NoneRaisedDepressedUniformDropshadow

Font Family

Proportional Sans-SerifMonospace Sans-SerifProportional SerifMonospace SerifCasualScriptSmall Caps

Reset restore all settings to the default valuesDone

Close Modal Dialog

End of dialog window.

Close Modal Dialog

This is a modal window. This modal can be closed by pressing the Escape key or activating the close button.

This is part of the Get Going with JMP series.

Resources:

• Documentation on how to create formulas in the Formula Editor
• Documentation on using local variables in the Formula Editor

[Laura_Higgins]

This might be a good reference for this topic: https://www.jmp.com/support/help/en/16.2/#page/jmp/use-local-variables-in-formulas.shtml

[NaomiReyes]

Hello, "Unit Data" table missing from .zip. Lot 2 formula column missing from Process Data table, but I was able to directly code from your screen. Thanks! (Using JMP 17.1)