How to specify a custom expression for a summary value (Enterprise Manager)

To specify a custom expression for a summary value

1. Specify the groups for your query. For details, see Grouping Rows in Query Results.
2. Move to a blank row of the Grid Pane, and then type the expression in the Columns column.

   The Query Designer automatically assigns a column alias to the expression to create a useful column heading in query output. For more details, see Creating Column Aliases.

3. In the Group By column for the expression, select Expression.