Every defined formula has a base table, and some has a contextual table also.
horizontal formulas not only have a base table (as do all formulas) but also have a contexutal table. For the formula be well defined, it is needed its base table belongs to the contextual extended table. Thus, you can include all the attributes you need as long as they belong to the formula base table and its extended table.
Aggregate Formulas base table is the table to be navigated by the formula in order to make the calculation. Besides, the formula may be in a context where there is an instantiated table (the contextual table), which may or may not have some relationship with the formula base table.Thus, when you define an Aggregate Formula you can involve in its definition:
- attributes that belong to the contextual base table and its extended table
- attributes that belong to the desired navigated table (base table) and its extended table
The navigated table in an Aggregate formula is inferred by GeneXus through the attributes mentioned in the formula, among those not belonging to the contextual base table and its extended.
In general, as we said, in an Aggregate formula you can involve all the attributes you need as long as they belong to the formula contextual table and its extended table (because they are available when the formula is triggered). Besides, when you define the Aggregate formula, you know which must be the navigated table in order to make the calculation, so you can include in its definition all the attributes you need as long as they belong to the desired navigated table and its extended table.
If you define a formula using attributes that don't fullfil these rules, an error will be reported in the resulting navigation report at specification time.
As of GeneXus X Evolution 3 we have changed the terminology. What we used to call formula base table, is now contextual table, and what we used to call navigated table is now formula base table.