Specify a computed column

Create, edit, or delete a computed column No tip for this topic No example for this topic Move a column or computed column

You can specify a computed column as one of the following:

Specifying a function

A function is a mathematical function that evaluates to a value.

To specify a computed column that is a function:

  1. Specify the argument of the function, if any.
  2. From the Unary operator menu, select Left operand and then the function you want to use.

Example:

Specifying an expression

An expression is a mathematical expression that evaluates to a value.

To specify a computed column that is an expression:

  1. Specify the left operand of the expression.

    To apply a function or unary operator to the left operand you have specified, from the Unary operator menu, select Left operand and then the function or unary operator you want to apply.

  2. Select the binary operator of the expression.
  3. Specify the right operand of the expression.

Example:

Specifying a compound expression

A compound expression is an expression that consists of other expressions.

To specify a computed column that is a compound expression:

  1. Specify one of the expressions contained in the compound expression by following the same steps as for specifying an expression.
  2. Select Add to operand lists.
  3. Repeat the steps above for each expression contained in the compound expression.
  4. Specify the left operand of the compound expression.
  5. Select the binary operator of the compound expression.
  6. Specify the right operand of the compound expression.

Example:

(((WAGES.SALARY - WAGES.TAXES) * 12) + WAGES.BONUS)