Creating a Calculated Value

A calculated value is a temporary field that is evaluated after all the data that meets the selection criteria is retrieved, sorted, and summed.

  1. Click the Expressions drop-down list on the Data Assist ribbon and click Summary Expression.

    The Add Summary expression calculator opens, as shown in the following image.

  2. Create the expression.

    For more information about creating an expression see Using the Expression Calculator.

  3. Click OK.
Information Builders