If you create a formula that refers to values found in table variables, those table variables must already exist in the data table. Table variables are character strings that are available to the entire table. Their names are displayed in the table panel at the left of the data table. (For details, see Use Table Variables in Enter and Edit Data.)
The following example shows how to re-create a formula column in the Companies.jmp sample data table.
|
1.
|
|
2.
|
Right-click the last empty column and select New Columns.
|
You are re-creating the formula found in the existing %profit/sales column.
|
5.
|
With the box selected, select Profits ($M) from the Columns list.
|
.
|
7.
|
With the box selected as shown, select Sales ($M) from the Columns list.
|
.
|
11.
|
Click OK.
|
|
13.
|
In the Column Info window, select Fixed Dec from the Format list, type “10” next to Width, and type “2” next to Dec.
|
|
14.
|
Click OK.
|
The new formula column matches the %profit/sales formula column.
|
•
|
The right-click menu for the Columns list has two new items: Replace all occurrences of selected subexpression. replaces all occurrences of the selected expression with the currently selected column. Replace the selected subexpression with columns. replaces the selected expression with multiple columns (formerly Shift + Click) for functions that support it (for example, Sum or Plus).
|