Formulae - Calculations in applications

1. General

Formulae can be used to create calculations in Intrexx applications. These can be created with the "Calculation" element or in the column properties in view tables, to display the sum or cumulative values beneath the table. Calculations can also be performed within table rows and columns. Click here for more information about where you can use the formula editor.

2. Intrexx Formulae




In the formula editor, you can access the Intrexx Formulae on the Libraries tab. If you select an entry in the library, you can access these buttons at the bottom right of this area:

Show description
Shows the description of the currently selected function with an example script.

Open link
Links to the corresponding page that provides more information. The page that opens also shows the classes, interfaces, methods or properties that the currently selected function can be used for.

2.1. Operators

Mathematical operators form the basis of formulae that can be used to perform standard calculations such as addition and subtraction. Logical operators can also be used.
Logical operators return double values as a result instead of Boolean values. 1.00 means true, 0.00 means false.

2.1.1. Arithmetical

2.1.1.1. Addition

+

2.1.1.2. Subtraction

-

2.1.1.3. Multiplication

*

2.1.1.4. Division

/

2.1.2. Comparison

2.1.2.1. Less than

<

2.1.2.2. Greater than

>

2.1.2.3. Less than or equal to

<=

2.1.2.4. Greater than or equal to

>=

2.1.2.5. Equal to

==

2.1.2.6. Not equal to

!=

2.1.3. Logical

2.1.3.1. Logical AND connection

All values have to meet the criteria for an AND connection. 
&&

2.1.3.2. Logical OR connection

At least one value has to meet the criteria for an OR connection. 
||

2.1.3.3. Negation

Returns all values that the criteria does not apply to. 
!

2.2. Values

On application pages, values from diverse sources such as elements or data groups can be read and used in formulae.
Example: 
//Read the value of an integer or double control with the fallback value 0.
//The GUID corresponds to the GUID of the control.
control("3A8788BDE1561CAF449890BAF01D6306B4F8E6AC", 0)
The methods available here are descibed below.

2.2.1. Value from current record

2.2.1.1. Value from control

Read the value of an integer or double control with the fallback value 0.
control("<controlGuid>")
control("<controlGuid>", <fallbackValue>) 
control("<controlGuid>", <fallbackValue>)

2.2.1.2. Value from control (string)

Read the number value of a string control with the fallback value 0.
controlAsNumber("<controlGuid>")
controlAsNumber("<controlGuid>", <fallbackValue>) 
controlAsNumber("<controlGuid>", <fallbackValue>)

2.2.1.3. Value from calculation

Read the content of another calculation control. Please make sure that you do not define loops between calculation controls.
formula("<formulaGuid>")
formula("<formulaGuid>", <fallbackValue>) 
formula("<formulaGuid>", <fallbackValue>)

2.2.1.4. Value from data field

Read a value using the GUID of the desired data field.
dataField("<dataFieldGuid>")
dataField("<dataFieldGuid>", <fallbackValue>) 
dataField("<dataFieldGuid>", <fallbackValue>)

2.2.1.5. Value from data field (string)

Read a string number value using the GUID of the desired data field.
dataFieldAsNumber("<dataFieldGuid>")
dataFieldAsNumber("<dataFieldGuid>", <fallbackValue>) 
dataFieldAsNumber("<dataFieldGuid>", <fallbackValue>)

2.2.1.6. Child records

Various aggregate functions can be performed on child data records.
Example: 
//Calculate the sum of a data field from the child data group
childSum(dataGroup("669F2C0747A5FFBB4FB2C7829945071E1ED5B0CB"), dataField("9AA6E0484980D633B43DB53D9B11AF22962667B4", 0))

2.2.1.6.1. Sum of child records

Sum of a data field over all child data records of the current parent record from the child data group.
childSum(dataGroup("<dataGroupGuid>"), dataField("<dataFieldGuid>", <fallbackValue>))
childSum(dataGroup("<dataGroupGuid>"), dataFieldAsNumber("<dataFieldGuid>", <fallbackValue>)) 
childSum(dataGroup("<dataGroupGuid>"), dataField("<dataFieldGuid>", <fallbackValue>))

2.2.1.6.2. Minimum of child records

Minimum of a data field value of all child data records of the current parent record from the child data group.
childMin(dataGroup("<dataGroupGuid>"), dataField("<dataFieldGuid>", <fallbackValue>))
childMin(dataGroup("<dataGroupGuid>"), dataFieldAsNumber("<dataFieldGuid>", <fallbackValue>)) 
childMin(dataGroup("<dataGroupGuid>"), dataField("<dataFieldGuid>", <fallbackValue>))

2.2.1.6.3. Maximum of child records

Maximum of a data field value of all child data records of the current parent record from the child data group.
childMax(dataGroup("<dataGroupGuid>"), dataField("<dataFieldGuid>", <fallbackValue>))
childMax(dataGroup("<dataGroupGuid>"), dataFieldAsNumber("<dataFieldGuid>", <fallbackValue>)) 
childMax(dataGroup("<dataGroupGuid>"), dataField("<dataFieldGuid>", <fallbackValue>))

2.2.1.6.4. Number of child records

Calculate the number of child data records for the current parent record.
childCount(dataGroup("<dataGroupGuid>"), dataField("<dataFieldGuid>", <fallbackValue>))
childCount(dataGroup("<dataGroupGuid>"), dataFieldAsNumber("<dataFieldGuid>", <fallbackValue>)) 
childCount(dataGroup("<dataGroupGuid>"), dataField("<dataFieldGuid>", <fallbackValue>))

2.2.1.6.5. Average value of child records

Calculate the average value of a data field over all child data records of the current parent record from the child data group.
childAvg(dataGroup("<dataGroupGuid>"), dataField("<dataFieldGuid>", <fallbackValue>))
childAvg(dataGroup("<dataGroupGuid>"), dataFieldAsNumber("<dataFieldGuid>", <fallbackValue>)) 
childAvg(dataGroup("<dataGroupGuid>"), dataField("<dataFieldGuid>", <fallbackValue>))

2.2.2. Value from table

Calculation controls can be defined as a new column in view tables. The defined formula can be performed for every table row.
Example: 
//Calculate the product of two column values (e.g. Amount * Item price)
//The GUIDs of the desired table columns need to be stated.
row("FDBD14318DD7A434AD5131D5C26D630E8F292530", 0) * row("C6CA5368F24171BD6EDBF63C3B83F49FF1813C11", 0)

2.2.2.1. Value from current row

2.2.2.1.1. Value from control

Access a column value with a fallback value.
row("<tableControlGuid>")
row("<tableControlGuid>", <fallbackValue>) 
row("<tableControlGuid>", <fallbackValue>)

2.2.2.1.2. Value from control (string)

Access a string column value with a fallback value.
rowAsNumber("<tableControlGuid>")
rowAsNumber("<tableControlGuid>", <fallbackValue>) 
rowAsNumber("<tableControlGuid>", <fallbackValue>)

2.2.2.1.3. Value from calculation

Access a column formula with a fallback value.
rowFormula("<tableFormulaGuid>")
rowFormula("<tableFormulaGuid>", <fallbackValue>) 
rowFormula("<tableFormulaGuid>", <fallbackValue>)

2.2.2.1.4. Value from data field

Access a column value using the data field GUID with a fallback value.
rowDataField("<tableDataFieldGuid>")
rowDataField("<tableDataFieldGuid>", <fallbackValue>) 
rowDataField("<tableDataFieldGuid>", <fallbackValue>)

2.2.2.1.5. Value from data field (string)

Access a string column value using the data field GUID with a fallback value.
rowDataFieldAsNumber("<tableDataFieldGuid>")
rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>) 
rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>)

2.2.2.1.6. Child records

If the current data group has child data groups, you can access the child records of the current record and perform various aggregate functions on them. 
//Calculate the sum of a data field from the child data group.
//The GUIDs of the child data group and child data field need to be stated.
childSum(dataGroup("669F2C0747A5FFBB4FB2C7829945071E1ED5B0CB"), rowDataField("9AA6E0484980D633B43DB53D9B11AF22962667B4", 0))

2.2.2.1.6.1. Sum of child records

Sum of a data field over all child data records of the current parent record from the child data group.
childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
childSum(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>)) 
childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))

2.2.2.1.6.2. Minimum of child records

Minimum of a data field value of all child data records of the current parent record from the child data group.
childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
childMin(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>)) 
childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))

2.2.2.1.6.3. Maximum of child records

Maximum of a data field value of all child data records of the current parent record from the child data group.
childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
childMax(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>)) 
childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))

2.2.2.1.6.4. Number of child records

Calculate the number of child data records of the current parent record.
childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
childCount(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>)) 
childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))

2.2.2.1.6.5. Average value of child records

Calculate the average value of a data field over all child data records of the current parent record from the child data group.
childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
childAvg(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>)) 
childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))

2.2.2.2. Value from total calculation

2.2.2.2.1. Value from calculation

formula("<tableFormulaGuid>")
formula("<tableFormulaGuid>", <fallbackValue>) 
formula("<tableFormulaGuid>", <fallbackValue>)

2.2.2.3. System value

In addition to values form records, you can also access various system values such as data from sessions or system data groups in formulae. 
//Read a value of the system data group
//The data field name needs to be stated.
systemField(("L_VERSION"), 0)

2.2.2.3.1. Session value

Read the value of a user session.
session("<variable>")
session("<variable>", <fallbackValue>) 
session("<variable>", <fallbackValue>)

2.2.2.3.2. Session value (string)

Read a string value from a user session.
sessionAsNumber("<variable>")
sessionAsNumber("<variable>", <fallbackValue>) 
sessionAsNumber("<variable>", <fallbackValue>)

2.2.2.3.3. Value from processing context

Read a value from the current processing context (sharedState).
sharedState("<variable>")
sharedState("<variable>", <fallbackValue>) 
sharedState("<variable>", <fallbackValue>)

2.2.2.3.4. Value from processing context (string)

Read a string value from the current processing context (sharedState).
sharedStateAsNumber("<variable>")
sharedStateAsNumber("<variable>", <fallbackValue>) 
sharedStateAsNumber("<variable>", <fallbackValue>)

2.2.2.3.5. Request value

Read a value from a request.
requestAsNumber("<variable>")
requestAsNumber("<variable>", <fallbackValue>) 
requestAsNumber("<variable>", <fallbackValue>)

2.2.2.3.6. Value from system data group

Read a value from the system data group.
systemField("<variable>")
systemField("<variable>", <fallbackValue>) 
systemField("<variable>", <fallbackValue>)

2.2.2.3.7. Value from system data group (string)

Read a string value from the system data group.
systemFieldAsNumber("<variable>")
systemFieldAsNumber("<variable>", <fallbackValue>) 
systemFieldAsNumber("<variable>", <fallbackValue>)

2.2.2.4. null

null

2.2.2.5. true

true

2.2.2.6. false

false

2.3. Functions

2.3.1. Error handling

The fallback values shown in the previous examples are used if the requested value, the desired control etc. is undefined (null). However, this does not handle server errors that may occur during the calculation. This may occur, if a value from a string data field should be used in a formula but the value cannot be parsed to a number, for example. This always occurs if non-numerical characters are the value. In these situations, a value will not be displayed in the calculation control but simply "An error has occurred". This may be wanted in some circumstances to find erroneous data quickly. If it is not wanted, such server errors can be dealt with separately. 
//Read a string value and return 0 in the case of error
zeroOnError(rowAsNumber("117B9589365400BBF5B72540565F75D42496BE73"))

//Read a string value and return 1 in the case of error
oneOnError(rowAsNumber("117B9589365400BBF5B72540565F75D42496BE73"))

//Read a string value and return a custom value in the case of error
fallbackOnError(rowAsNumber("117B9589365400BBF5B72540565F75D42496BE73"), -1)

2.3.1.1. Return of 0 in the case of error

zeroOnError(<value>)

2.3.1.2. Return of 1 in the case of error

oneOnError(<value>)

2.3.1.3. Return custom value in the case of error

fallbackOnError(<value>, <fallback>)

2.3.2. Rounding functions

Round functions are available to round stored or calculated number values based on specific criteria or mathematical procedures.

2.3.2.1. roundLong

roundLong(<value>)

2.3.2.2. roundLongHalfAwayFromZero

roundLongHalfAwayFromZero(<value>)

2.3.2.3. roundLongHalfEven

roundLongHalfEven(<value>)

2.3.2.4. roundLongHalfUp

roundLongHalfUp(<value>)

2.3.2.5. roundLongHalfDown

roundLongHalfDown(<value>)

2.3.2.6. round

round(<value>, <scale>)

2.3.2.7. roundHalfAwayFromZero

roundHalfAwayFromZero(<value>, <scale>)

2.3.2.8. roundHalfEven

roundHalfEven(<value>, <scale>)

2.3.2.9. roundHalfUp

roundHalfUp(<value>, <scale>)

2.3.2.10. roundHalfDown

roundHalfDown(<value>, <scale>)

2.3.3. Case differentiation

To only perform more complex calculations in some circumstances, case differentiation can be defined. 
//Basic structure
case(BOOLEAN_EXPRESSION, TRUE_EXPRESSION, FALSE_EXPRESSION)
caseNot(BOOLEAN_EXPRESSION, TRUE_EXPRESSION, FALSE_EXPRESSION)

//If the sum is greater than 1000, the result of a formula should be used, otherwise a static value of 1000.
case(totalSum(table("A2391263105FD17F556A68A10AECC63115AEF217"), row("E605C89A571DDD8112A252A48256A92555A5E794")) > 1000, 
formula("26D6E15533B8AD9AFCE9BB36672F2F9912C5CB73", 0), 
1000)
In addition to comparing number values, string values can also be checked in a Boolean expression. A calculation is therefore only performed, if the connected order has a certain status, for example. 
//Read an order status
case(equalsIgnoreCase(rowDataField("062FA7D7B2F1651C5037307B0E3E1FB2B107969F", ""), "Ordered"), true, false)

2.3.3.1. Case

case(<booleanExpression>, <trueExpression>, <falseExpression>)

2.3.3.2. Case not

caseNot(<booleanExpression>, <trueExpression>, <falseExpression>)

2.3.3.3. Boolean expressions

2.3.3.3.1. Equal to

equals(<string1>, <string2>)

2.3.3.3.2. Equal to (ignore case sensitivity)

equalsIgnoreCase(<string1>, <string2>)

2.3.3.3.3. Begins with

startsWith(<string>, <prefix>)

2.3.3.3.4. Begins with (ignore case sensitivity)

startsWithIgnoreCase(<string>, <prefix>)

2.3.3.3.5. Ends with

endsWith(<string>, <suffix>)

2.3.3.3.6. Ends with (ignore case sensitivity)

endsWithIgnoreCase(<string>, <suffix>)

2.3.3.3.7. Contains

contains(<string>, <sequence>)

2.3.3.3.8. Contains (ignore case sensitivity)

containsIgnoreCase(<string>, <sequence>)

2.3.3.3.9. Test for empty string

isEmpty(<string>)

2.3.3.3.10. Test for empty string or null value

isNullOrEmpty(<string>)

2.3.3.3.11. Test for null value

isNull(<value>)

2.3.4. Mathematical

2.3.4.1. Absolute value

abs(<value>)

2.3.5. Table functions

2.3.5.1. Aggregate functions for column values

In many cases, a calculation of the values displayed in a table needs to be displayed beneath the table. These calculations include sums, sub totals and average values. There are three options to cover different use cases (shown here with the example of a sum calculation): 
//Calculate the sum of all data shown here.
sum(table("TABLE_GUID"), row("CONTROL_GUID"))	

//Calculate the sum of all data from page 1 to the displayed page.
//Is only different from sum if the table has a table navigation element and the user is not on the first page.
subTotalSum(table("TABLE_GUID"), row("CONTROL_GUID"))

//Sum of all data records displayed in the table regardless of which page is currently being displayed.
totalSum(table("TABLE_GUID"), row("CONTROL_GUID"))
Analogous methods are available for:

Maximalwert

max/subTotalMax/totalMax

Minimalwert

min/subTotalMin/totalMin

Number

count/subTotalCount/totalCount

Average value

avg/subTotalAvg/totalAvg

Please note that the total methods are computation-intensive operations. If you have a large amount of data, you may encounter corresponding delays.

2.3.5.1.1. Column values of records (current view)

2.3.5.1.1.1. Sum

2.3.5.1.1.1.1. Sum from control

Calculate the sum of all data currently being displayed.
sum(table("<tableGuid>"), row("<tableControlGuid>"))
sum(table("<tableGuid>"), row("<tableControlGuid>", <fallbackValue>))
sum(table("<tableGuid>"), rowAsNumber("<tableControlGuid>"))
sum(table("<tableGuid>"), rowAsNumber("<tableControlGuid>", <fallbackValue>)) 
sum(table("<tableGuid>"), row("<tableControlGuid>", <fallbackValue>))

2.3.5.1.1.1.2. Sum from calculation

sum(table("<tableGuid>"), rowFormula("<tableFormulaGuid>"))
sum(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>)) 
sum(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))

2.3.5.1.1.1.3. Sum from data field

sum(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>"))
sum(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
sum(table("<tableGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>"))
sum(table("<tableGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>)) 
sum(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))

2.3.5.1.1.1.4. Child records

2.3.5.1.1.1.4.1. Sum of the sums of child records

sum(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
sum(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
sum(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
sum(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
sum(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.1.1.4.2. Sum of minima of child records

sum(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
sum(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
sum(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
sum(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
sum(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.1.1.4.3. Sum of maxima of child records

sum(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
sum(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
sum(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
sum(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
sum(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.1.1.4.4. Sum of number of child records

sum(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
sum(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
sum(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
sum(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
sum(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.1.1.4.5. Sum of average values of child records

sum(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
sum(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
sum(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
sum(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
sum(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.1.2. Maximum

2.3.5.1.1.2.1. Maximum from control

max(table("<tableGuid>"), row("<tableControlGuid>"))
max(table("<tableGuid>"), row("<tableControlGuid>", <fallbackValue>))
max(table("<tableGuid>"), rowAsNumber("<tableControlGuid>"))
max(table("<tableGuid>"), rowAsNumber("<tableControlGuid>", <fallbackValue>)) 
max(table("<tableGuid>"), row("<tableControlGuid>", <fallbackValue>))

2.3.5.1.1.2.2. Maximum from calculation

max(table("<tableGuid>"), rowFormula("<tableFormulaGuid>"))
max(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>)) 
max(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))

2.3.5.1.1.2.3. Maximum from data field

max(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>"))
max(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
max(table("<tableGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>"))
max(table("<tableGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>)) 
max(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))

2.3.5.1.1.2.4. Child records

2.3.5.1.1.2.4.1. Maximum of the sums of child records

max(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
max(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
max(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
max(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
max(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.1.2.4.2. Maximum of minima of child records

max(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
max(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
max(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
max(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
max(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.1.2.4.3. Maximum of maxima of child records

max(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
max(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
max(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
max(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
max(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.1.2.4.4. Maximum of number of child records

max(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
max(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
max(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
max(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
max(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.1.2.4.5. Maximum of average values of child records

max(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
max(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
max(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
max(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
max(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.1.3. Minimum

2.3.5.1.1.3.1. Minimum from control

min(table("<tableGuid>"), row("<tableControlGuid>"))
min(table("<tableGuid>"), row("<tableControlGuid>", <fallbackValue>))
min(table("<tableGuid>"), rowAsNumber("<tableControlGuid>"))
min(table("<tableGuid>"), rowAsNumber("<tableControlGuid>", <fallbackValue>)) 
min(table("<tableGuid>"), row("<tableControlGuid>", <fallbackValue>))

2.3.5.1.1.3.2. Minimum from calculation

min(table("<tableGuid>"), rowFormula("<tableFormulaGuid>"))
min(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>)) 
min(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))

2.3.5.1.1.3.3. Minimum from data field

min(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>"))
min(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
min(table("<tableGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>"))
min(table("<tableGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>)) 
min(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))

2.3.5.1.1.3.4. Child records

2.3.5.1.1.3.4.1. Maximum of the sums of child records

min(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
min(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
min(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
min(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
min(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.1.3.4.2. Minimum of minima of child records

min(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
min(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
min(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
min(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
min(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.1.3.4.3. Minimum of maxima of child records

min(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
min(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
min(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
min(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
min(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.1.3.4.4. Minimum of number of child records

min(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
min(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
min(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
min(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
min(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.1.3.4.5. Minimum of average values of child records

min(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
min(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
min(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
min(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
min(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.1.4. Number

2.3.5.1.1.4.1. Number from control

count(table("<tableGuid>"), row("<tableControlGuid>"))
count(table("<tableGuid>"), row("<tableControlGuid>", <fallbackValue>))
count(table("<tableGuid>"), rowAsNumber("<tableControlGuid>"))
count(table("<tableGuid>"), rowAsNumber("<tableControlGuid>", <fallbackValue>)) 
count(table("<tableGuid>"), row("<tableControlGuid>", <fallbackValue>))

2.3.5.1.1.4.2. Number from calculation

count(table("<tableGuid>"), rowFormula("<tableFormulaGuid>"))
count(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>)) 
count(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))

2.3.5.1.1.4.3. Number from data field

count(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>"))
count(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
count(table("<tableGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>"))
count(table("<tableGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>)) 
count(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))

2.3.5.1.1.4.4. Child records

2.3.5.1.1.4.4.1. Number of the sums of child records

count(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
count(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
count(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
count(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
count(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.1.4.4.2. Number of minima of child records

count(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
count(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
count(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
count(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
count(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.1.4.4.3. Number of maxima of child records

count(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
count(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
count(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
count(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
count(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.1.4.4.4. Number of number of child records

count(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
count(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
count(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
count(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
count(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.1.4.4.5. Number of average values of child records

count(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
count(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
count(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
count(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
count(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.1.5. Average value

2.3.5.1.1.5.1. Average value from control

avg(table("<tableGuid>"), row("<tableControlGuid>"))
avg(table("<tableGuid>"), row("<tableControlGuid>", <fallbackValue>))
avg(table("<tableGuid>"), rowAsNumber("<tableControlGuid>"))
avg(table("<tableGuid>"), rowAsNumber("<tableControlGuid>", <fallbackValue>)) 
avg(table("<tableGuid>"), row("<tableControlGuid>", <fallbackValue>))

2.3.5.1.1.5.2. Average value from calculation

avg(table("<tableGuid>"), rowFormula("<tableFormulaGuid>"))
avg(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>)) 
avg(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))

2.3.5.1.1.5.3. Average value from data field

avg(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>"))
avg(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
avg(table("<tableGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>"))
avg(table("<tableGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>)) 
avg(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))

2.3.5.1.1.5.4. Child records

2.3.5.1.1.5.4.1. Average value of the sums of child records

avg(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
avg(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
avg(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
avg(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
avg(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.1.5.4.2. Average value of minima of child records

avg(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
avg(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
avg(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
avg(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
avg(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.1.5.4.3. Average value of maxima of child records

avg(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
avg(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
avg(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
avg(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
avg(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.1.5.4.4. Average value of number of child records

avg(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
avg(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
avg(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
avg(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
avg(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.1.5.4.5. Average value of average values of child records

avg(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
avg(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
avg(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
avg(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
avg(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.2. Column values of records (subtotal)

2.3.5.1.2.1. Sum

2.3.5.1.2.1.1. Sum from control

subTotalSum(table("<tableGuid>"), row("<tableControlGuid>"))
subTotalSum(table("<tableGuid>"), row("<tableControlGuid>", <fallbackValue>))
subTotalSum(table("<tableGuid>"), rowAsNumber("<tableControlGuid>"))
subTotalSum(table("<tableGuid>"), rowAsNumber("<tableControlGuid>", <fallbackValue>)) 
subTotalSum(table("<tableGuid>"), row("<tableControlGuid>", <fallbackValue>))

2.3.5.1.2.1.2. Sum from calculation

subTotalSum(table("<tableGuid>"), rowFormula("<tableFormulaGuid>"))
subTotalSum(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>)) 
subTotalSum(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))

2.3.5.1.2.1.3. Sum from data field

subTotalSum(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>"))
subTotalSum(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
subTotalSum(table("<tableGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>"))
subTotalSum(table("<tableGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>)) 
subTotalSum(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))

2.3.5.1.2.1.4. Child records

2.3.5.1.2.1.4.1. Sum of the sums of child records

subTotalSum(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
subTotalSum(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
subTotalSum(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
subTotalSum(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
subTotalSum(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.2.1.4.2. Sum of minima of child records

subTotalSum(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
subTotalSum(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
subTotalSum(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
subTotalSum(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
subTotalSum(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.2.1.4.3. Sum of maxima of child records

subTotalSum(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
subTotalSum(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
subTotalSum(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
subTotalSum(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
subTotalSum(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.2.1.4.4. Sum of number of child records

subTotalSum(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
subTotalSum(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
subTotalSum(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
subTotalSum(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
subTotalSum(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.2.1.4.5. Sum of average values of child records

subTotalSum(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
subTotalSum(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
subTotalSum(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
subTotalSum(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
subTotalSum(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.2.2. Maximum

2.3.5.1.2.2.1. Maximum from control

subTotalMax(table("<tableGuid>"), row("<tableControlGuid>"))
subTotalMax(table("<tableGuid>"), row("<tableControlGuid>", <fallbackValue>))
subTotalMax(table("<tableGuid>"), rowAsNumber("<tableControlGuid>"))
subTotalMax(table("<tableGuid>"), rowAsNumber("<tableControlGuid>", <fallbackValue>)) 
subTotalMax(table("<tableGuid>"), row("<tableControlGuid>", <fallbackValue>))

2.3.5.1.2.2.2. Maximum from calculation

subTotalMax(table("<tableGuid>"), rowFormula("<tableFormulaGuid>"))
subTotalMax(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>)) 
subTotalMax(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))

2.3.5.1.2.2.3. Maximum from data field

subTotalMax(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>"))
subTotalMax(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
subTotalMax(table("<tableGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>"))
subTotalMax(table("<tableGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>)) 
subTotalMax(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))

2.3.5.1.2.2.4. Child records

2.3.5.1.2.2.4.1. Maximum of the sums of child records

subTotalMax(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
subTotalMax(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
subTotalMax(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
subTotalMax(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
subTotalMax(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.2.2.4.2. Maximum of minima of child records

subTotalMax(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
subTotalMax(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue<)))
subTotalMax(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
subTotalMax(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
subTotalMax(table(">tableGuid<"), childMin(dataGroup(">tableDataGroupGuid<"), rowDataField(">tableDataFieldGuid<", >fallbackValue<)))

2.3.5.1.2.2.4.3. Maximum of maxima of child records

subTotalMax(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
subTotalMax(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
subTotalMax(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
subTotalMax(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
subTotalMax(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.2.2.4.4. Maximum of number of child records

subTotalMax(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
subTotalMax(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", >fallbackValue>)))
subTotalMax(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
subTotalMax(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", >fallbackValue>))) 
subTotalMax(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.2.2.4.5. Maximum of average values of child records

2.3.5.1.2.3. Minimum

2.3.5.1.2.3.1. Minimum from control

subTotalMin(table("<tableGuid>"), row("<tableControlGuid>"))
subTotalMin(table("<tableGuid>"), row("<tableControlGuid>", <fallbackValue>))
subTotalMin(table("<tableGuid>"), rowAsNumber("<tableControlGuid>"))
subTotalMin(table("<tableGuid>"), rowAsNumber("<tableControlGuid>", <fallbackValue>)) 
subTotalMin(table("<tableGuid>"), row("<tableControlGuid>", <fallbackValue>))

2.3.5.1.2.3.2. Minimum from calculation

subTotalMin(table("<tableGuid>"), rowFormula("<tableFormulaGuid>"))
subTotalMin(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>)) 
subTotalMin(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))

2.3.5.1.2.3.3. Minimum from data field

subTotalMin(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>"))
subTotalMin(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
subTotalMin(table("<tableGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>"))
subTotalMin(table("<tableGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>)) 
subTotalMin(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))

2.3.5.1.2.3.4. Child records

2.3.5.1.2.3.4.1. Maximum of the sums of child records

subTotalMin(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
subTotalMin(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
subTotalMin(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
subTotalMin(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
subTotalMin(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.2.3.4.2. Minimum of minima of child records

subTotalMin(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
subTotalMin(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
subTotalMin(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
subTotalMin(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
subTotalMin(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.2.3.4.3. Minimum of maxima of child records

subTotalMin(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
subTotalMin(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
subTotalMin(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
subTotalMin(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
subTotalMin(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.2.3.4.4. Minimum of number of child records

subTotalMin(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
subTotalMin(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
subTotalMin(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
subTotalMin(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
subTotalMin(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.2.3.4.5. Minimum of average values of child records

2.3.5.1.2.4. Number

2.3.5.1.2.4.1. Number from control

subTotalCount(table("<tableGuid>"), row("<tableControlGuid>"))
subTotalCount(table("<tableGuid>"), row("<tableControlGuid>", <fallbackValue>))
subTotalCount(table("<tableGuid>"), rowAsNumber("<tableControlGuid>"))
subTotalCount(table("<tableGuid>"), rowAsNumber("<tableControlGuid>", <fallbackValue>)) 
subTotalCount(table("<tableGuid>"), row("<tableControlGuid>", <fallbackValue>))

2.3.5.1.2.4.2. Number from calculation

subTotalCount(table("<tableGuid>"), rowFormula("<tableFormulaGuid>"))
subTotalCount(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
subTotalCount(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))

2.3.5.1.2.4.3. Number from data field

subTotalCount(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>"))
subTotalCount(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
subTotalCount(table("<tableGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>"))
subTotalCount(table("<tableGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>)) 
subTotalCount(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))

2.3.5.1.2.4.4. Child records

2.3.5.1.2.4.4.1. Number of the sums of child records

subTotalCount(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
subTotalCount(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
subTotalCount(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
subTotalCount(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
subTotalCount(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.2.4.4.2. Number of minima of child records

subTotalCount(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
subTotalCount(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
subTotalCount(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
subTotalCount(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
subTotalCount(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.2.4.4.3. Number of maxima of child records

subTotalCount(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
subTotalCount(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
subTotalCount(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
subTotalCount(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
subTotalCount(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.2.4.4.4. Number of number of child records

subTotalCount(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
subTotalCount(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
subTotalCount(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
subTotalCount(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
subTotalCount(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.2.4.4.5. Number of average values of child records

subTotalCount(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
subTotalCount(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
subTotalCount(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
subTotalCount(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
subTotalCount(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.2.5. Average value

2.3.5.1.2.5.1. Average value from control

subTotalAvg(table("<tableGuid>"), row("<tableControlGuid>"))
subTotalAvg(table("<tableGuid>"), row("<tableControlGuid>", <fallbackValue>))
subTotalAvg(table("<tableGuid>"), rowAsNumber("<tableControlGuid>"))
subTotalAvg(table("<tableGuid>"), rowAsNumber("<tableControlGuid>", <fallbackValue>)) 
subTotalAvg(table("<tableGuid>"), row("<tableControlGuid>", <fallbackValue>))

2.3.5.1.2.5.2. Average value from calculation

subTotalAvg(table("<tableGuid>"), rowFormula("<tableFormulaGuid>"))
subTotalAvg(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>)) 
subTotalAvg(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))

2.3.5.1.2.5.3. Average value from data field

subTotalAvg(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>"))
subTotalAvg(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
subTotalAvg(table("<tableGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>"))
subTotalAvg(table("<tableGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>)) 
subTotalAvg(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))

2.3.5.1.2.5.4. Child records

2.3.5.1.2.5.4.1. Average value of the sums of child records

subTotalAvg(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
subTotalAvg(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
subTotalAvg(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
subTotalAvg(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
subTotalAvg(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.2.5.4.2. Average value of minima of child records

subTotalAvg(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
subTotalAvg(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
subTotalAvg(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
subTotalAvg(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
subTotalAvg(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.2.5.4.3. Average value of maxima of child records

subTotalAvg(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
subTotalAvg(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
subTotalAvg(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
subTotalAvg(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
subTotalAvg(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.2.5.4.4. Average value of number of child records

subTotalAvg(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
subTotalAvg(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
subTotalAvg(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
subTotalAvg(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
subTotalAvg(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.2.5.4.5. Average value of average values of child records

subTotalAvg(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
subTotalAvg(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
subTotalAvg(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
subTotalAvg(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
subTotalAvg(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.3. Column values of all records

2.3.5.1.3.1. Sum

2.3.5.1.3.1.1. Sum from control

totalSum(table("<tableGuid>"), row("<tableControlGuid>"))
totalSum(table("<tableGuid>"), row("<tableControlGuid>", <fallbackValue>))
totalSum(table("<tableGuid>"), rowAsNumber("<tableControlGuid>"))
totalSum(table("<tableGuid>"), rowAsNumber("<tableControlGuid>", <fallbackValue>)) 
totalSum(table("<tableGuid>"), row("<tableControlGuid>", <fallbackValue>))

2.3.5.1.3.1.2. Sum from calculation

totalSum(table("<tableGuid>"), rowFormula("<tableFormulaGuid>"))
totalSum(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>)) 
totalSum(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))

2.3.5.1.3.1.3. Sum from data field

totalSum(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>"))
totalSum(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
totalSum(table("<tableGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>"))
totalSum(table("<tableGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>)) 
totalSum(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))

2.3.5.1.3.1.4. Child records

2.3.5.1.3.1.4.1. Sum of the sums of child records

totalSum(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
totalSum(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
totalSum(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
totalSum(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
totalSum(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.3.1.4.2. Sum of minima of child records

totalSum(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
totalSum(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
totalSum(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
totalSum(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
totalSum(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.3.1.4.3. Sum of maxima of child records

totalSum(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
totalSum(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
totalSum(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
totalSum(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
totalSum(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.3.1.4.4. Sum of number of child records

totalSum(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
totalSum(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
totalSum(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
totalSum(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
totalSum(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.3.1.4.5. Sum of average values of child records

totalSum(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
totalSum(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
totalSum(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
totalSum(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
totalSum(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.3.2. Maximum

2.3.5.1.3.2.1. Maximum from control

totalMax(table("<tableGuid>"), row("<tableControlGuid>"))
totalMax(table("<tableGuid>"), row("<tableControlGuid>", <fallbackValue>))
totalMax(table("<tableGuid>"), rowAsNumber("<tableControlGuid>"))
totalMax(table("<tableGuid>"), rowAsNumber("<tableControlGuid>", <fallbackValue>)) 
totalMax(table("<tableGuid>"), row("<tableControlGuid>", <fallbackValue>))

2.3.5.1.3.2.2. Maximum from calculation

totalMax(table("<tableGuid>"), rowFormula("<tableFormulaGuid>"))
totalMax(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>)) 
totalMax(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))

2.3.5.1.3.2.3. Maximum from data field

totalMax(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>"))
totalMax(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
totalMax(table("<tableGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>"))
totalMax(table("<tableGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>)) 
totalMax(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))

2.3.5.1.3.2.4. Child records

2.3.5.1.3.2.4.1. Maximum of the sums of child records

totalMax(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
totalMax(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
totalMax(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
totalMax(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
totalMax(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.3.2.4.2. Maximum of minima of child records

totalMax(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
totalMax(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
totalMax(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
totalMax(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
totalMax(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.3.2.4.3. Maximum of maxima of child records

totalMax(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
totalMax(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
totalMax(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
totalMax(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
totalMax(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.3.2.4.4. Maximum of number of child records

totalMax(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
totalMax(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
totalMax(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
totalMax(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
totalMax(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.3.2.4.5. Maximum of average values of child records

totalMax(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
totalMax(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
totalMax(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
totalMax(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
totalMax(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.3.3. Minimum

2.3.5.1.3.3.1. Minimum from control

totalMin(table("<tableGuid>"), row("<tableControlGuid>"))
totalMin(table("<tableGuid>"), row("<tableControlGuid>", <fallbackValue>))
totalMin(table("<tableGuid>"), rowAsNumber("<tableControlGuid>"))
totalMin(table("<tableGuid>"), rowAsNumber("<tableControlGuid>", <fallbackValue>)) 
totalMin(table("<tableGuid>"), row("<tableControlGuid>", <fallbackValue>))

2.3.5.1.3.3.2. Minimum from calculation

totalMin(table("<tableGuid>"), rowFormula("<tableFormulaGuid>"))
totalMin(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>)) 
totalMin(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))

2.3.5.1.3.3.3. Minimum from data field

totalMin(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>"))
totalMin(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
totalMin(table("<tableGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>"))
totalMin(table("<tableGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>)) 
totalMin(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))

2.3.5.1.3.3.4. Child records

2.3.5.1.3.3.4.1. Maximum of the sums of child records

totalMin(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
totalMin(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
totalMin(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
totalMin(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
totalMin(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)));))

2.3.5.1.3.3.4.2. Minimum of minima of child records

totalMin(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
totalMin(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
totalMin(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
totalMin(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
totalMin(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.3.3.4.3. Minimum of maxima of child records

totalMin(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
totalMin(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
totalMin(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
totalMin(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
totalMin(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.3.3.4.4. Minimum of number of child records

totalMin(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
totalMin(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
totalMin(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
totalMin(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
totalMin(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.3.3.4.5. Minimum of average values of child records

totalMin(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
totalMin(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
totalMin(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
totalMin(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
totalMin(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.3.4. Number

2.3.5.1.3.4.1. Number from control

totalCount(table("<tableGuid>"), row("<tableControlGuid>"))
totalCount(table("<tableGuid>"), row("<tableControlGuid>", <fallbackValue>))
totalCount(table("<tableGuid>"), rowAsNumber("<tableControlGuid>"))
totalCount(table("<tableGuid>"), rowAsNumber("<tableControlGuid>", <fallbackValue>)) 
totalCount(table("<tableGuid>"), row("<tableControlGuid>", <fallbackValue>))

2.3.5.1.3.4.2. Number from calculation

totalCount(table("<tableGuid>"), rowFormula("<tableFormulaGuid>"))
totalCount(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>)) 
totalCount(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))

2.3.5.1.3.4.3. Number from data field

totalCount(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>"))
totalCount(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
totalCount(table("<tableGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>"))
totalCount(table("<tableGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>)) 
totalCount(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))

2.3.5.1.3.4.4. Child records

2.3.5.1.3.4.4.1. Number of the sums of child records

totalCount(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
totalCount(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
totalCount(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
totalCount(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
totalCount(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.3.4.4.2. Number of minima of child records

totalCount(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
totalCount(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
totalCount(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
totalCount(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
totalCount(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.3.4.4.3. Number of maxima of child records

totalCount(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
totalCount(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
totalCount(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
totalCount(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
totalCount(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.3.4.4.4. Number of number of child records

totalCount(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
totalCount(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
totalCount(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
totalCount(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
totalCount(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.3.4.4.5. Number of average values of child records

totalCount(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
totalCount(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
totalCount(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
totalCount(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
totalCount(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.3.5. Average value

2.3.5.1.3.5.1. Average value from control

totalAvg(table("<tableGuid>"), row("<tableControlGuid>"))
totalAvg(table("<tableGuid>"), row("<tableControlGuid>", <fallbackValue>))
totalAvg(table("<tableGuid>"), rowAsNumber("<tableControlGuid>"))
totalAvg(table("<tableGuid>"), rowAsNumber("<tableControlGuid>", <fallbackValue>)) 
totalAvg(table("<tableGuid>"), row("<tableControlGuid>", <fallbackValue>))

2.3.5.1.3.5.2. Average value from calculation

totalAvg(table("<tableGuid>"), rowFormula("<tableFormulaGuid>"))
totalAvg(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>)) 
totalAvg(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))

2.3.5.1.3.5.3. Average value from data field

totalAvg(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>"))
totalAvg(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
totalAvg(table("<tableGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>"))
totalAvg(table("<tableGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>)) 
totalAvg(table("<tableGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))

2.3.5.1.3.5.4. Child records

2.3.5.1.3.5.4.1. Average value of the sums of child records

totalAvg(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
totalAvg(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
totalAvg(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
totalAvg(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
totalAvg(table("<tableGuid>"), childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.3.5.4.2. Average value of minima of child records

totalAvg(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
totalAvg(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
totalAvg(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
totalAvg(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
totalAvg(table("<tableGuid>"), childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.3.5.4.3. Average value of maxima of child records

totalAvg(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
totalAvg(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
totalAvg(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
totalAvg(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
totalAvg(table("<tableGuid>"), childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.3.5.4.4. Average value of number of child records

totalAvg(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
totalAvg(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
totalAvg(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
totalAvg(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
totalAvg(table("<tableGuid>"), childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.5.1.3.5.4.5. Average value of average values of child records

totalAvg(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>")))
totalAvg(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))
totalAvg(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>")))
totalAvg(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))) 
totalAvg(table("<tableGuid>"), childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>)))

2.3.6. Date functions

To calculate deadlines, due dates and other use cases, you can perform calculations with date and time values. These include system data such as the creation date, values from data and time fields and the current time.

2.3.6.1. Functions for single date values

If a value should be determined from a single date value, the following methods can be used as demonstrated. For all methods, the time zone to be used can be stated as the second parameter. 
//Current hour of the current date in the time zone Europe/Berlin
hour(currentDateTime, "Europe/Berlin")

//Day of the month from a date value from a data field. Time zone is not specified.
//As a result, the time zone of the current user is taken into account
dayOfMonth(dataField("2DA5429B4BE959EBE28B18E0BAB8C4705C789D1A", -1))

2.3.6.1.1. Day of year

Day of the year.
dayOfYear("<dateExpression>", "<timeZone>")
dayOfYear("<dateExpression>") 
dayOfYear("<dateExpression>", "<timeZone>")

2.3.6.1.2. Day of month

Day of the month.
dayOfMonth("<dateExpression>", "<timeZone>")
dayOfMonth("<dateExpression>") 
dayOfMonth("<dateExpression>", "<timeZone>")

2.3.6.1.3. Day of week

Day of the week with Monday as the first day of the week.
dayOfWeek("<dateExpression>", "<timeZone>")
dayOfWeek("<dateExpression>") 
dayOfWeek("<dateExpression>", "<timeZone>")

2.3.6.1.4. Week of year (week starts on Monday)

Week of the year with Monday as the first day of the week.
weekOfYear("<dateExpression>", "<timeZone>")
weekOfYear("<dateExpression>")
weekOfYearISO("<dateExpression>", "<timeZone>")
weekOfYearISO("<dateExpression>") 
weekOfYear("<dateExpression>", "<timeZone>")

2.3.6.1.5. Week of year (week starts on Sunday)

Week of the year with Sunday as the first day of the week.
weekOfYearSunday("<dateExpression>", "<timeZone>")
weekOfYearSunday("<dateExpression>") 
weekOfYearSunday("<dateExpression>", "<timeZone>")

2.3.6.1.6. Year

Year from the date.
year("<dateExpression>", "<timeZone>")
year("<dateExpression>") 
year("<dateExpression>", "<timeZone>")

2.3.6.1.7. Month

Month from the date (January = 1, Feburary = 2, ...)
month("<dateExpression>", "<timeZone>")
month("<dateExpression>") 
month("<dateExpression>", "<timeZone>")

2.3.6.1.8. Hour

Hour from the date.
hour("<dateExpression>", "<timeZone>")
hour("<dateExpression>") 
hour("<dateExpression>", "<timeZone>")

2.3.6.1.9. Minute

Minutes from the date.
minute("<dateExpression>", "<timeZone>")
minute("<dateExpression>") 
minute("<dateExpression>", "<timeZone>")

2.3.6.1.10. Second

Seconds from the date.
second("<dateExpression>", "<timeZone>")
second("<dateExpression>") 
second("<dateExpression>", "<timeZone>")

2.3.6.1.11. Millisecond

Milliseconds from the date.
millisecond("<dateExpression>", "<timeZone>")
millisecond("<dateExpression>")
millis("<dateExpression>", "<timeZone>")
millis("<dateExpression>") 
millisecond("<dateExpression>", "<timeZone>")

2.3.6.2. Difference between two date values

To calculate the different between two date values, the following methods can be used: 
//Difference in days between a date value and the current date
diffInDay(dataField("C2FA3A0DD01E7E6612972A7A97D8DDCA1709CF3E", -1), currentDateTime)

2.3.6.2.1. Difference in days

Different between two date values in days.
diffInDay("<dateExpression1>", "<dateExpression2>")

2.3.6.2.2. Difference in hours

Different between two date values in hours.
diffInHour("<dateExpression1>", "<dateExpression2>")

2.3.6.2.3. Difference in minutes

Different between two date values in minutes.
diffInMinute("<dateExpression1>", "<dateExpression2>")

2.3.6.2.4. Difference in seconds

Different between two date values in seconds.
diffInSecond("<dateExpression1>", "<dateExpression2>")

2.3.6.2.5. Difference in milliseconds

Different between two date values in milliseconds.
diffInMillisecond("<dateExpression1>", "<dateExpression2>")

2.3.6.3. Date expressions

In the same way as number values, date values can also be read from data fields, rows in tables etc.

2.3.6.3.1. Date from current record

2.3.6.3.1.1. Date from control

Date value from a control.
controlAsDateTime("<controlGuid>")
controlAsDateTime("<controlGuid>", <fallbackValue>) 
controlAsDateTime("<controlGuid>", <fallbackValue>)

2.3.6.3.1.2. Date from data field

Date value from a data field.
dataFieldAsDateTime("<dataFieldGuid>")
dataFieldAsDateTime("<dataFieldGuid>", <fallbackValue>) 
dataFieldAsDateTime("<dataFieldGuid>", <fallbackValue>)

2.3.6.3.2. Date from table

2.3.6.3.2.1. Date from current row

2.3.6.3.2.1.1. Date from control

Date value from the current table row.
rowAsDateTime("<tableControlGuid>")
rowAsDateTime("<tableControlGuid>", <fallbackValue>) 
rowAsDateTime("<tableControlGuid>", <fallbackValue>)

2.3.6.3.2.1.2. Date from data field

Date value from the current table row using the data field GUID in a view table.
rowDataFieldAsDateTime("<tableDataFieldGuid>")
rowDataFieldAsDateTime("<tableDataFieldGuid>", <fallbackValue>) 
rowDataFieldAsDateTime("<tableDataFieldGuid>", <fallbackValue>)

2.3.6.3.3. Date from system value

2.3.6.3.3.1. Date from session value

Date value from a session variable.
sessionAsDateTime("<variable>")
sessionAsDateTime("<variable>", <fallbackValue>) 
sessionAsDateTime("<variable>", <fallbackValue>)

2.3.6.3.3.2. Date from processing context

Date value from a sharedState variable.
sharedStateAsDateTime("<variable>")
sharedStateAsDateTime("<variable>", <fallbackValue>) 
sharedStateAsDateTime("<variable>", <fallbackValue>)

2.3.6.3.3.3. Date from request value

Date value from a request variable.
requestAsDateTime("<variable>")
requestAsDateTime("<variable>", <fallbackValue>) 
requestAsDateTime("<variable>", <fallbackValue>)

2.3.6.3.3.4. Date from system data group

Date value from the value of a system data field.
systemFieldAsDateTime("<systemFieldGuid>")
systemFieldAsDateTime("<systemFieldGuid>", <fallbackValue>) 
systemFieldAsDateTime("<systemFieldGuid>", <fallbackValue>)

2.3.6.3.4. Date from string value

Date value from a string.
dateTime("<dateTimeString>", "<dateTimeFormat>", "<timeZone>")
dateTime("<dateTimeString>", "<dateTimeFormat>")
z.B. dateTime("2014-01-01T12:00:00Z", "yyyy-MM-dd'T'HH:mm:ss'Z'", "UTC") 
dateTime("<dateTimeString>", "<dateTimeFormat>", "<timeZone>")

2.3.6.3.5. Current date

Returns the current date. 
currentDateTime

2.3.6.3.6. Current date from request

Returns the date from the last request. 
currentRequestDateTime