Using Table and Record Control Functions in Formulas

The Table and Record controls have a number of functions available that operate on these controls.

Table control functions

These functions are available for all Table controls on a page:

In some cases, to make functions easier to use, there is an alternative interface provided for the functions.  For example, the SUM() function requires a table control and the name of a literal, textbox or label user interface control.  This function then goes through all of the literal controls within the table control and sums the values in each row.  Normally, this function is called as:

= SUM(OrderDetailsTableControl, “ExtendedPrice”)

To provide an alternative implementation, the SUM() function can also be called as follows:

= OrderDetailsTableControl.SUM(“ExtendedPrice”)

The recommend approach is to use the second, alternative implementation to make it easier to understand.

Record control functions

The following functions are implemented for the Base Application Record Control and are available for all Record Controls and Table Control Rows on a page:

See Also

Variables Available in Formulas

Formula Evaluation Order

Indexing

Using Table and Record Control Functions in Formulas

Using .NET Framework Functions in Formulas

Using Custom Functions in Formulas

Formula Error Reporting