Formulae - Calculations in applications
Contents
General
Intrexx Formulae
Operators
Arithmetical
Addition
Subtraction
Multiplication
Division
Comparison
Less than
Greater than
Less than or equal to
Greater than or equal to
Equal to
Not equal to
Logical
Logical AND connection
Logical OR connection
Negation
Values
Value from current record
Value from control
Value from control (string)
Value from calculation
Value from data field
Value from data field (string)
Child records
Sum of child records
Minimum of child records
Maximum of child records
Number of child records
Average value of child records
Value from table
Value from current row
Value from control
Value from control (string)
Value from calculation
Value from data field
Value from data field (string)
Child records
Sum of child records
Minimum of child records
Maximum of child records
Number of child records
Average value of child records
Value from total calculation
Value from calculation
System value
Session value
Session value (string)
Value from processing context
Value from processing context (string)
Request value
Value from system data group
Value from system data group (string)
null
true
false
Functions
Error handling
Return of 0 in the case of error
Return of 1 in the case of error
Return custom value in the case of error
Rounding functions
roundLong
roundLongHalfAwayFromZero
roundLongHalfEven
roundLongHalfUp
roundLongHalfDown
round
roundHalfAwayFromZero
roundHalfEven
roundHalfUp
roundHalfDown
Case differentiation
Case
Case not
Boolean expressions
Equal to
Equal to (ignore case sensitivity)
Begins with
Begins with (ignore case sensitivity)
Ends with
Ends with (ignore case sensitivity)
Contains
Contains (ignore case sensitivity)
Test for empty string
Test for empty string or null value
Test for null value
Mathematical
Absolute value
Table functions
Aggregate functions for column values
Column values of records (current view)
Sum
Sum from control
Sum from calculation
Sum from data field
Child records
Sum of the sums of child records
Sum of minima of child records
Sum of maxima of child records
Sum of number of child records
Sum of average values of child records
Maximum
Maximum from control
Maximum from calculation
Maximum from data field
Child records
Maximum of the sums of child records
Maximum of minima of child records
Maximum of maxima of child records
Maximum of number of child records
Maximum of average values of child records
Minimum
Minimum from control
Minimum from calculation
Minimum from data field
Child records
Maximum of the sums of child records
Minimum of minima of child records
Minimum of maxima of child records
Minimum of number of child records
Minimum of average values of child records
Number
Number from control
Number from calculation
Number from data field
Child records
Number of the sums of child records
Number of minima of child records
Number of maxima of child records
Number of number of child records
Number of average values of child records
Average value
Average value from control
Average value from calculation
Average value from data field
Child records
Average value of the sums of child records
Average value of minima of child records
Average value of maxima of child records
Average value of number of child records
Average value of average values of child records
Column values of records (subtotal)
Sum
Sum from control
Sum from calculation
Sum from data field
Child records
Sum of the sums of child records
Sum of minima of child records
Sum of maxima of child records
Sum of number of child records
Sum of average values of child records
Maximum
Maximum from control
Maximum from calculation
Maximum from data field
Child records
Maximum of the sums of child records
Maximum of minima of child records
Maximum of maxima of child records
Maximum of number of child records
Maximum of average values of child records
Minimum
Minimum from control
Minimum from calculation
Minimum from data field
Child records
Minimum of the sums of child records
Minimum of minima of child records
Minimum of maxima of child records
Minimum of number of child records
Minimum of average values of child records
Number
Number from control
Number from calculation
Number from data field
Child records
Number of the sums of child records
Number of minima of child records
Number of maxima of child records
Number of number of child records
Number of average values of child records
Average value
Average value from control
Average value from calculation
Average value from data field
Child records
Average value of the sums of child records
Average value of minima of child records
Average value of maxima of child records
Average value of number of child records
Average value of average values of child records
Column values of all records
Sum
Sum from control
Sum from calculation
Sum from data field
Child records
Sum of the sums of child records
Sum of minima of child records
Sum of maxima of child records
Sum of number of child records
Sum of average values of child records
Maximum
Maximum from control
Maximum from calculation
Maximum from data field
Child records
Maximum of the sums of child records
Maximum of minima of child records
Maximum of maxima of child records
Maximum of number of child records
Maximum of average values of child records
Minimum
Minimum from control
Minimum from calculation
Minimum from data field
Child records
Maximum of the sums of child records
Minimum of minima of child records
Minimum of maxima of child records
Minimum of number of child records
Minimum of average values of child records
Number
Number from control
Number from calculation
Number from data field
Child records
Number of the sums of child records
Number of minima of child records
Number of maxima of child records
Number of number of child records
Number of average values of child records
Average value
Average value from control
Average value from calculation
Average value from data field
Child records
Average value of the sums of child records
Average value of minima of child records
Average value of maxima of child records
Average value of number of child records
Average value of average values of child records
Date functions
Functions for single date values
Day of year
Day of month
Day of week
Week of year (week starts on Monday)
Week of year (week starts on Sunday)
Year
Month
Hour
Minute
Second
Millisecond
Difference between two date values
Difference in days
Difference in hours
Difference in minutes
Difference in seconds
Difference in milliseconds
Date expressions
Date from current record
Date from control
Date from data field
Date from table
Date from current row
Date from control
Date from data field
Date from system value
Date from session value
Date from processing context
Date from request value
Date from system data group
Date from string value
Current date
Current date from request
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.
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