An expression column is used to create an expression which is a combination of data columns, operators and built-in functions. This expression column will act as a calculated measure that can be configured to report item like other normal numeric columns as a quantitative measure.
Click on the Expression
icon in the query designer toolbar to open Query Expressions
dialog.
Now the Query Expressions
dialog will be launched like below.
Note: The expression icon in the tools pane will be in disabled state, if there is no table found dropped in table design view.
Add
button in the Query Expressions
dialog .Expression1
.
Define an expression in an Expression text area. The syntax for defining a simple expression is,
{function name(}[columnname]{operator[columnname])…}
where, content within curly braces is optional.
Some expressions for reference:
Expression
text area, double click on the respective function or column name in the Functions or Column Settings list view.
Save
button.
Column Settings
list view like below.
Refer Supported Built-in functions section to know more about supported built-in functions.
Name
and Expression
fields as required.Save
button to save the changes.Click on the delete
icon in the expression field to delete an expression column.
To close the dialog click on the Cancel
button in dialog footer or Close
icon in the dialog header.