Use tablix field expressions

1. Select the cell in the table that you want to add the expression and select the properties icon ().
2. Select the square icon () next to the Content field and select Expression.
3. In the Expression dialog, enter the expression in the Set Expression for : Content field.

   You can also use the values in the Options and Data sections to create the expression.

4. Select OK.
5. Select Save Report to save your changes.

Example: Display the currency or number sum at the group footer

1. In the Expression dialog, select Fields from the dropdown and select the appropriate field from the list in the Data section.

   The Set Expression For : Content field is then populated with the expression. For example, =Sum(Fields!POSubtotal.Value).

2. Select OK.

Example: Use the First and Sum functions together

In the Fixed Lump Sum - Prime Contract Item Invoice History report, the following expression is used in the Set Expression For : Content field:

=First (Fields!ItemSubtotal.Value) - Sum(Fields!PrimeInvItemCurrentTotal.Value)

The First function is used because the prime contract or change order (CO ) item might appear in multiple transactions. Using the Sum function will incorrectly add up the same value multiple times.