You can create a computed column whose values are determined by a given value
To create a computed column in a table:
In an open table or worksheet, click
The Create Computed Column dialog is presented.
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.
In the Column Heading text box, enter the text that will
appear at the top of the column when the table is displayed.
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
Note: On most American keyboards, the
` character is immediately to the left of
In the Value Expression text box, enter a mathematical
formula that will determine the value of the computed column.
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
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
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.
Select the Display Format from the drop-down list.
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.
Select the Column Width from the drop-down list.
This is the desired width of the column (number of characters).
Note: If set
to Default, the width is determined by the
Select the Decimal Places from the drop-down list.
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.
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.