Table of contents

Official Content

It is possible to use Data Selector objects in Aggregate Formulas.


Data Selectors can be referenced in Aggregate formulas, with the USING clause according to the following grammar:

<AggFormulaName> (<Expression>, [<AggregationCondition>], [<DefaultValue>])

View Syntax conventions


     Could be one of the following: Find, Max, Min, Sum, Count, or Average.

     Is an expression to be found, maximized, minimized, summed, or averaged. It can be an attribute (stored or formula), or an expression that involves attributes, variables, and constants.

     Is composed of [<Condition>] [USING <DataSelector> '(' <Parameters...> ')']

     Is the returned value when no records match the AggregateCondition. It is a constant and it is optional.


  • For Count formulas, the first parameter can't be an expression. On the other hand, it must be an attribute.
  • For Sum and Count formulas, the result of evaluating the expression must be a numeric value.
  • When using a Data Selector (USING clause), the use of Procedures is not suported in the formula definition. Otherwise, the spc0026 will be detailed and the formula cannot be solved.
  • User variables can only be used in inline formulas.


Consider the following Transaction objects:



Consider the "ActiveCustomers" Data Selector definition as follows:

DataSelector Example A V18

1) To count the total number of active customers you can define inside an event, source, etc. the following code:

  &NumberActiveCustomers = Count(CustomerName, USING ActiveCustomers())

2) To count the number of active customers per country you can define the following code:

For Each Country
   &NumberActiveCustomers = Count(CustomerName, USING ActiveCustomers())

Something important to know is that the CustomerName attribute -the first parameter in the count formula- is not taken into account by GeneXus to determine the For Each Base Table. The CustomerName attribute belongs to the Formula definition.

The For Each base table is COUNTRY (because Country is mentioned as Base Transaction).

The table navigated by the Formula (in which the calculation is made) is CUSTOMER (because the attributes mentioned in the formula and in the Data Selector definitions belong to the CUSTOMER table).

Finally, the two tables that are navigated, COUNTRY and CUSTOMER, have a common attribute: CountryId. So, for each navigated country (by the For Each command), the Aggregate Formula defined inside the For Each (inline) considers only the active customers that belong to the country being navigated in the For Each query, at the moment of triggering the formula.

See Also

Data Selectors in Grids
Data Selectors in Data Providers
Data Selectors in For Each command
Data Selectors in Web Panels
Work With List Node
Entry Panels as Filters for a List in Smart Devices


Start Video Data Selectors

Last update: November 2023 | © GeneXus. All rights reserved. GeneXus Powered by Globant