Using Table Data Field Functions

After you enable table data and select the source by using the table object's Table Data property page, special Table Data Field data sources become available to help you design your table. These Table Data Field data sources are listed in the Data Sources pane of the Toolbox, and you can drag them to table cells to create a text object that is linked to the data source. For more information about how to add a Table Data Field data source to an object, refer to Creating Tables that Use Dynamic Data.

After you link a Table Data Field data source to an object, you can configure its properties by using the object's Data Sources property page. The property page includes settings that you can specify to calculate sum or other aggregate functions in the Table Data Field data source.

The following types of functions are available:

Sum: Calculates the total of all the values in the specified range for the Table Data Field data source. Supported for numeric values.
Average: Calculates the average of all the values in the specified range for the Table Data Field data source. Supported for numeric values.
Minimum: Determines the minimum value in the specified range for the Table Data Field data source. Supported for numeric values and date values. Also supported for text values, where it can determine the first string, as sorted by a case-sensitive, neutral language comparison.
Maximum: Determines the maximum value in the specified range for the Table Data Field data source. Supported for numeric values and date values. Also supported for text values, where it can determine the last string, as sorted by a case-sensitive, neutral language comparison.
Count: Calculates the number of records in the specified range.
List (Comma-Separated Value): Concatenates all record values in the specified range into one long string in which the values are separated by commas.
List (Tab-Separated Value): Concatenates all record values in the specified range into one long string in which the values are separated by tabs.
List (Single Value Per Line): Concatenates all record values in the specified range into one long string in which the values are separated by line breaks.

You can also specify the range for which the function is calculated. The following range options are available:

All Records: Calculates the function by using all records that are listed in the table.
Current Page: Calculates the function by using all records that are listed in the table as it appears on a single printed item.

You can use a Table Data Field data source outside of the table in which it is defined, but when you do this, only an aggregate function can be used for the data source. The function defaults to Sum, and the Range defaults to All Records (currently, Group is not supported). A typical use for this configuration would be to place the total price in an object outside of the table in which it is defined.