<< Click to Display Table of Contents >>

 

To edit the unbound field's expression, use the Expression Editor. Select the Expression Editor menu command to invoke it.

Expressions allow you to calculate values based on values of other fields.

_EU_ExpressionEditorInvoking

An expression is a string that, when parsed and processed, evaluates a value. Expressions consist of field names, constants, operators, and functions. Field names must be wrapped in brackets. Here are examples of expressions:

"[Quantity] * [UnitPrice] * (1 - [BonusAmount])"

"[FirstName] + ' ' + [LastName]"

"[Country] == 'USA'"

"[OrderDate] > #8/16/1994# AND [Quantity] > 20"

For more information about syntax you can use in expressions, see Pivot Grid Expression Syntax.