User Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Learning Center

Videos, activities, learning paths, and articles to help you learn and grow your curiosity about JMP. From novice to advanced JMP users, the Learning Library has content for everyone.
Choose Language Hide Translation Bar
Using Formulas and the Formula Editor
Created: May 5, 2022 12:18 PM  |  Last Modified: Jun 14, 2022 2:06 PM
formula data tables.zip

See how to make and edit formulas in JMP

Laura_Higgins_0-1653070913682.png

 

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.

 

(view in My Videos)

 

 

This is part of the Get Going with JMP series.

 

Resources:

Comments
Laura_Higgins
‎05-24-2022 05:34 PM

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
‎06-20-2024 10:24 AM

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)