Publication date: 07/15/2025

Evaluate Formulas

By default, JMP evaluates each formula that you create. You can turn this evaluation off, or you can use it before you have finished creating a formula.

Suppress Evaluation

Turning off evaluation is a useful formula development mode when building complex formulas. You can turn off evaluation while building sections of a formula, and then enable it only to test the formula. In particular, you can close the Formula Editor and reopen it at a later time to continue building a formula without JMP evaluating it.

To suppress formula evaluation, click the red triangle next to the keypad and select Suppress Eval. When evaluation is suppressed, the formula button Image shown here appears dimmed.

Notes:

If the formula button appears to the right of the red triangle in the Formula Editor, it indicates that formula evaluation is suppressed for that formula.

If the formula button appears beside the column name in the Columns panel, it indicates that the values in the column result from a formula. See “Icons That Represent Column Characteristics and Properties”.

To turn off formula evaluation for all formulas, click the red triangle next to the data table name and select Suppress Formula Eval. To re-evaluate formulas, click the red triangle next to the data table name and select Rerun Formulas. You can also click the Apply button in the Formula Editor for each column that contains a pending formula.

When you turn off formula evaluation, edit a formula, and click Apply, you are prompted to choose whether to evaluate the formula. To allow formula evaluation once, click Evaluate formula this time.

Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).