Configure an expression calculation

An expression allows you to create a simple calculation for which you must use aggregates.

An example of a simple calculation created from an expression is (AggregateA + AggregateB)/AggregateC.

You can build an expression calculation by using the SQL arithmetic operators and aggregate calculations.

When you create an expression, you must ensure that the execution of the expression will not trigger SQL exceptions. For example, the expression should include logic to catch a potential division by zero. If such exceptions occur, the object reports an error at each scheduled execution and record insertion will stop at the time of the error.

Configure an expression calculation

1. Click Edit Calculations.

2. In the Context & Calculations pane, click a calculation that you want to configure.

3. In the Calculation type list, click Expression.

   

4. In the Return type list, click a return data type for the expression. The default return data type is Double.

5. In the Expression area, build an expression calculation. Do the following:

   1. In the Available calculations area, double-click an aggregate calculation that you want to use in expression calculation. The Available calculations area shows the aggregate calculations of the current measure that have a numeric return type.

   2. In the Operators area, click an operator to use in expression calculation.

      The expression built in the SQL Expression editor must be a valid Microsoft SQL Server expression.

6. Click Save.