The Table and Record controls have a number of functions available that operate on these controls.
These functions are available for all Table controls on a page:
SUM
MAX
MIN
COUNT
COUNTA
MEAN
AVERAGE
MODE
MEDIAN
RANGE
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.
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:
RANK
ROWNUM
RUNNINGTOTAL
Variables Available in Formulas
Using Table and Record Control Functions in Formulas
Using .NET Framework Functions in Formulas
Using Custom Functions in Formulas