When you add a column to a report in the Report Editor, you can specify that you want to use an SQL function. The Calculation Builder provides a guided interface to help you define SQL expressions for use in reports.
-
In the Report Editor, click +Column in the Columns section.
-
Click Calculations, and select the SQL function that you want
to use. The Calculation Builder opens and displays a description of the function and its
use.
-
In the Function input section, define the SQL expression. Use the down arrow to
display either a subset of options that are likely to have the parameter you are looking
for, or all parameters.
You can build nested expressions by using an SQL function as the parameter value for
another SQL function.
-
Click Submit to apply your changes.