Edit Aggregate Binding dialog box

Use the Edit Aggregate Binding dialog box to specify aggregate binding for Edit and Static components.

Field/Option Description
Function From the drop-down list, select what type of aggregate operation to perform on the values returned for the component. For the types of operations and how they work, see the Aggregate functions table below.
Collection From the drop-down list, select the IDO collection to use for the aggregate operation.
Note: When you specify the collection, both the Property field and the Group By list are populated with the available properties.
Property From the drop-down list, select the property on which to perform the aggregate operation.

For Minimum, Maximum, and Count operations, this list is automatically filtered to include only properties that use numeric, date/time, and character data types. For Summation and Average operations, this list is filtered to include only properties that use numeric values.

Group By Optionally, use this option to specify a "group by" property. This can be used for things like showing a subtotal.

For example, you might want to display a subtotal of Sales per Customer. In this case, "SalesAmt" would be the property to select for the Property field, and "CustomerID" would be the property to select for the Group By option.

If, then, the current row’s CustomerID is “AcmeWidgets” this aggregate would total the sales amounts of all records in the current collection where CustomerID = "AcmeWidgets".

Table 1. Aggregate functions
Operation Description/Comments
(SUM) This aggregate adds the values and returns the total. It can be used only for properties with numeric values.
Minimum (MIN) The value depends on the data type:
  • Numeric value - Returns the least value.
  • Date/Time value - Returns the earliest date/time.
  • Character value - Returns the first character string ranked alphanumerically. For this calculation, the system uses the current system culture setting and ignores capitalization.
Maximum (MAX) The value depends on the data type:
  • Numeric value - Returns the greatest value.
  • Date/Time value - Returns the most recent date/time.
  • Character value - Returns the last character string ranked alphanumerically. For this calculation, the system uses the current system culture setting and ignores capitalization.
Average (AVG) This operation returns the mean average of the values returned. It can be used only for properties with numeric values.
Count (CNT) This operation returns the number of records where the specified property values are not null or not blank.