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.)
Tip: To create a table variable from a value in the Formula Editor, right-click the value and select Create Table Variable from Value.
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.
|
Figure 6.3 Adding the Profits ($M) Column
.
Figure 6.4 Adding the Division Symbol
|
7.
|
With the box selected as shown, select Sales ($M) from the Columns list.
|
Figure 6.5 Adding the Sales ($M) Column
Figure 6.6 Selecting the Formula
.
Figure 6.7 Adding the Multiplication Symbol
Figure 6.8 Multiplying the Formula by 100
|
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 replacement options: 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).
|