For the latest version of JMP Help, visit

Scripting Guide > Data Tables > Calculations > Calculator Formulas
Publication date: 07/30/2020

Calculator Formulas

You can store formulas in columns that are automatically evaluated to create the values in the cells of the column. If you open the formula, you get a calculator interface to edit the formula structurally. However, the formula is implemented with JSL, and you can obtain the text JSL form of any expression in the calculator by double-clicking it. The text can be edited, and when it is de-focused, it is compiled back into the structural form.

Note: There is no difference between a formula column created through the calculator window and one created directly through JSL with commands such as New Column(..., Formula(...)) or Col << Formula(...).

Want more information? Have questions? Get answers in the JMP User Community (