Specify a computed column
You can specify a computed column as one of the following:
• A function
• An expression
• A compound expression
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:
• Select MIN(X) to show MIN(EMPLOYEE.AGE)
• COUNT(*)
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.
a. If the right operand is a value, type the value in the field.
b. To apply a function or unary operator to the right operand you have specified, from the Unary operator menu, select Right operand and then the function or unary operator you want to apply.
Example:
• (JOBCODE + 10)
• (WAGES.SALARY - WAGES.TAXES)
• (-WAGES.TAXES)
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.
a. If the left operand is an expression you specified using the first two steps above, select it from the list.
b. 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.
5. Select the binary operator of the compound expression.
6. Specify the right operand of the compound expression.
a. If the right operand is an expression you specified using the first two steps above, select it from the list.
b. If the right operand is a value, type the value in the field.
c. To apply a function or unary operator to the right operand you have specified, from the Unary operator menu, select Right operand and then the function or unary operator you want to apply.
Example:
(((WAGES.SALARY - WAGES.TAXES) * 12) + WAGES.BONUS)
Last modified date: 08/13/2019