Create a computed column

You can create a computed column whose values are determined by a given value expression.

To create a computed column in a table:

  1. In an open table or worksheet, click Columns > Create Computed Column...

    The Create Computed Column dialog is presented.

  2. In the Column Name text box, enter the name that you wish to give to the column. (required)
    The column name is a way of referring to the column internally in value expressions and selection expressions. The column name must be a single word consisting of alphanumeric characters or underscores, and must begin with an alphabetic character (e.g., last_visit_date). It may not contain any spaces or other special characters.
    Note: This is different from the Column Heading, which is the text displayed at the top of the column.
  3. In the Column Heading text box, enter the text that will appear at the top of the column when the table is displayed. (optional)
    The column heading may contain any combination of uppercase and lowercase letters, numbers, spaces, and special characters. You may leave this blank, in which case the column's heading will be the same as its name. If you would like the heading to have more than one line, use ` to separate the lines (e.g., Date of`Last Visit).
    Note: On most American keyboards, the ` character is immediately to the left of 1.
  4. In the Value Expression text box, enter a mathematical formula that will determine the value of the computed column. (required)

    The value expression may refer to one or more columns and may include standard arithmetic, relational, and logical operators as well as any of the Macro Language functions.

    Note: When referring to a column in an expression, use the column name as opposed to the column heading. A list of all the column names for the table appears at the bottom of the Create Computed Column dialog.
  5. Select Treat special values as NA? if you want special values treated as N/A in calculations. (optional)

    Although the majority of table columns do not have special values, some columns have special values that represent a kind of missing value. Special values are specified when the data is initially loaded into the 1010data Insights Platform. To find out if a column has special values, show the column information for that column (or for all columns).

    Note: There is a performance degradation associated with selecting this option, so it is best to not select it unless special values are, in fact, present.

    In a Price column, for instance, a value of 999 might indicate that the price was unavailable, while a value of 888 might mean that it was not applicable. In both cases, the values would be treated as N/A rather than used in calculations if this option was selected.

  6. Select the Display Format from the drop-down list. (optional)
    The display format for the computed column specifies how the values will be displayed in the table.
    Note: If set to Default, the format is determined by the data.

    For example, dates are stored as integers in the 1010data Insights Platform (in YYYYMMDD form). To display a date as MM/DD/YYYY, choose the appropriate display format from the list.

  7. Select the Column Width from the drop-down list. (optional)
    This is the desired width of the column (number of characters).
    Note: If set to Default, the width is determined by the data.
  8. Select the Decimal Places from the drop-down list. (optional)
    This is the number of decimal places to show for numbers.
    Note: If set to Default, the number of decimal places is determined by the data and may be different for each row.
  9. Click Submit.
The computed column is added to the table.
Note: Computed columns apply only to your session and do not affect the original table or any other tables.