General
Formulae can be used to create calculations in Intrexx applications. Calculations can be defined with the "Calculation" element as well as in the column properties of view tables, e.g. to display totals or cumulative values below the table. Calculations can also be performed within table rows and columns.
Intrexx Formulae
In the formula editor, you have access to the Intrexx formula collection in the "Libraries" section. If you have selected an entry in the library, you will find the following buttons at the bottom right:
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.
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 can also be used. 1.00 means true, 0.00 means false.
Arithmetical
Addition
+
Subtraction
-
Multiplication
*
Division
/
Comparison
Less than
<
Greater than
>
Less than or equal
<=
Greater than or equal
>=
Equal to
==
Not equal to
!=
Logical
Logical AND connection
All values have to meet the criteria for an AND connection.
&&
Logical OR connection
At least one value has to meet the criteria for an OR connection.
||
Negation
Returns all values that the criteria does not apply to.
!
Values
On application pages, values from diverse sources such as elements or data groups can be read and used in formulae. Example:
//Reading a value from a control of type integer or double with fallback value 0.
//The GUID here corresponds to the GUID of the control to be read out
control("3A8788BDE1561CAF449890BAF01D6306B4F8E6AC", 0)
The methods available here are described below.
Value from current record
Value from control
Reads a value from a control of type integer or double with fallback value 0.
control("<controlGuid>")
control("<controlGuid>", <fallbackValue>)
control("<controlGuid>", <fallbackValue>)
Value from control (string)
Reads a numerical value from a control of type String with fallback value 0.
controlAsNumber("<controlGuid>")
controlAsNumber("<controlGuid>", <fallbackValue>)
controlAsNumber("<controlGuid>", <fallbackValue>)
Value from calculation
Read the content of another calculation control. Please ensure that you do not define any circular references between calculation controls.
formula("<formulaGuid>")
formula("<formulaGuid>", <fallbackValue>)
formula("<formulaGuid>", <fallbackValue>)
Value from data field
Read out a value using the GUID of the desired data field.
dataField("<dataFieldGuid>")
dataField("<dataFieldGuid>", <fallbackValue>)
dataField("<dataFieldGuid>", <fallbackValue>)
Value from data field (string)
Reads out a numerical value of type String using the GUID of the desired data field.
dataFieldAsNumber("<dataFieldGuid>")
dataFieldAsNumber("<dataFieldGuid>", <fallbackValue>)
dataFieldAsNumber("<dataFieldGuid>", <fallbackValue>)
Child data records
Various aggregate functions can be performed on child data records. Example:
//Calculation of the sum of a data field from the child data group
childSum(dataGroup("669F2C0747A5FFBB4FB2C7829945071E1ED5B0CB"), dataField("9AA6E0484980D633B43DB53D9B11AF22962667B4", 0))
Sum of child records
Sum of a data field across all child data records of the current parent data record from the child data group.
childSum(dataGroup("<dataGroupGuid>"), dataField("<dataFieldGuid>", <fallbackValue>))
childSum(dataGroup("<dataGroupGuid>"), dataFieldAsNumber("<dataFieldGuid>", <fallbackValue>))
childSum(dataGroup("<dataGroupGuid>"), dataField("<dataFieldGuid>", <fallbackValue>))
Minimum of child records
Minimum of a data field value of all child data records of the current parent data record from the child data group.
childMin(dataGroup("<dataGroupGuid>"), dataField("<dataFieldGuid>", <fallbackValue>))
childMin(dataGroup("<dataGroupGuid>"), dataFieldAsNumber("<dataFieldGuid>", <fallbackValue>))
childMin(dataGroup("<dataGroupGuid>"), dataField("<dataFieldGuid>", <fallbackValue>))
Maximum of child records
Maximum of a data field value of all child data records of the current parent data record from the child data group.
childMax(dataGroup("<dataGroupGuid>"), dataField("<dataFieldGuid>", <fallbackValue>))
childMax(dataGroup("<dataGroupGuid>"), dataFieldAsNumber("<dataFieldGuid>", <fallbackValue>))
childMax(dataGroup("<dataGroupGuid>"), dataField("<dataFieldGuid>", <fallbackValue>))
Number of child records
Calculation of the number of child data records for the current parent data record.
childCount(dataGroup("<dataGroupGuid>"), dataField("<dataFieldGuid>", <fallbackValue>))
childCount(dataGroup("<dataGroupGuid>"), dataFieldAsNumber("<dataFieldGuid>", <fallbackValue>))
childCount(dataGroup("<dataGroupGuid>"), dataField("<dataFieldGuid>", <fallbackValue>))
Average value of child records
Calculation of the average value of a data field across all child data records for the current parent data record.
childAvg(dataGroup("<dataGroupGuid>"), dataField("<dataFieldGuid>", <fallbackValue>))
childAvg(dataGroup("<dataGroupGuid>"), dataFieldAsNumber("<dataFieldGuid>", <fallbackValue>))
childAvg(dataGroup("<dataGroupGuid>"), dataField("<dataFieldGuid>", <fallbackValue>))
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:
//Calculation of the product of two column values (e.g. number of items * unit price)
//Specify the GUIDs of the desired table columns
row("FDBD14318DD7A434AD5131D5C26D630E8F292530", 0) * row("C6CA5368F24171BD6EDBF63C3B83F49FF1813C11", 0)
Value from current row
Value from control
Access to a column value with fallback value.
row("<tableControlGuid>")
row("<tableControlGuid>", <fallbackValue>)
row("<tableControlGuid>", <fallbackValue>)
Value from control (string)
Access to a column value of type String with fallback value.
rowAsNumber("<tableControlGuid>")
rowAsNumber("<tableControlGuid>", <fallbackValue>)
rowAsNumber("<tableControlGuid>", <fallbackValue>)
Value from calculation
Access to a column formula with fallback value.
rowFormula("<tableFormulaGuid>")
rowFormula("<tableFormulaGuid>", <fallbackValue>)
rowFormula("<tableFormulaGuid>", <fallbackValue>)
Value from data field
Access to a column value based on the data field GUID with fallback value.
rowDataField("<tableDataFieldGuid>")
rowDataField("<tableDataFieldGuid>", <fallbackValue>)
rowDataField("<tableDataFieldGuid>", <fallbackValue>)
Value from data field (string)
Access to a column value with fallback value.
rowDataFieldAsNumber("<tableDataFieldGuid>")
rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>)
rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>)
Child data records
If child data groups exist for the current data group, the child data records of the current data set can also be accessed and various aggregate functions can be executed on them.
//Calculation of the sum of a data field from the child data group
//The GUID of the child data group and the data field from the child data group must be specified here
childSum(dataGroup("669F2C0747A5FFBB4FB2C7829945071E1ED5B0CB"), rowDataField("9AA6E0484980D633B43DB53D9B11AF22962667B4", 0))
Sum of child records
Sum of a data field across all child data records of the current parent data record from the child data group.
childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
childSum(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))
childSum(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
Minimum of child records
Minimum of a data field value of all child data records of the current parent data record from the child data group.
childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
childMin(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))
childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
Maximum of child records
Maximum of a data field value of all child data records of the current parent data record from the child data group.
childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
childMax(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))
childMax(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
Number of child records
Calculation of the number of child data records for the current parent data record.
childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
childCount(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))
childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
Average value of child records
Calculation of the average value of a data field across all child data records for the current parent data record.
childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
childAvg(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))
childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
Value from total calculation
Value from calculation
formula("<tableFormulaGuid>")
formula("<tableFormulaGuid>", <fallbackValue>)
formula("<tableFormulaGuid>", <fallbackValue>)
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.
//Reading a value from a system data group
//Specify the data field name
systemField(("L_VERSION"), 0)
Session value
Read a value from the user session.
session <variable>>")
session("<variable>", <fallbackValue>)
session("<variable>", <fallbackValue>)
Session value (string)
Reads a value of type String from the user session.
sessionAsNumber("<variable>")
sessionAsNumber("<variable>", <fallbackValue>)
sessionAsNumber("<variable>", <fallbackValue>)
Value from processing context
Reading a value from the current processing context.
sharedState("<variable>")
sharedState("<variable>", <fallbackValue>)
sharedState("<variable>", <fallbackValue>)
Value from processing context (string)
Reads a value of type String from the current processing context.
sharedStateAsNumber("<variable>")
sharedStateAsNumber("<variable>", <fallbackValue>)
sharedStateAsNumber("<variable>", <fallbackValue>)
Request value
Read a value from the current request.
requestAsNumber("<variable>")
requestAsNumber("<variable>", <fallbackValue>)
requestAsNumber("<variable>", <fallbackValue>)
Value from system data group
Read a value from a system data group.
systemField("<variable>")
systemField("<variable>", <fallbackValue>)
systemField("<variable>", <fallbackValue>)
Value from system data group (string)
Read a value of type String from a system data group.
systemFieldAsNumber("<variable>")
systemFieldAsNumber("<variable>", <fallbackValue>)
systemFieldAsNumber("<variable>", <fallbackValue>)
null
null
true
true
false
false
Functions
Error handling
The fallback values shown in the previous examples apply in the event that the requested value, the desired control or similar is not available. is undefined (zero). However, this does not handle server errors that may occur during the calculation. This can be the case, for example, if a value from a string data field is to be used in a formula, but this value cannot be parsed to a number. This is the case for all non-numeric characters. In these situations, only "An error has occurred" is displayed in the calculation control instead of a value. This may be wanted in some circumstances to find erroneous data quickly. However, if this is not desired, such server errors can be started again separately.
//Reading of a string value and return of 0 in case of error
zeroOnError(rowAsNumber("117B9589365400BBF5B72540565F75D42496BE73"))
//Reading of a string value and return of 1 in case of error
oneOnError(rowAsNumber("117B9589365400BBF5B72540565F75D42496BE73"))
//Reading a string value and returning a user-defined value in case of error
fallbackOnError(rowAsNumber("117B9589365400BBF5B72540565F75D42496BE73"), -1)
Return of 0 in the case of error
zeroOnError(<value>)
Return of 1 in the case of error
oneOnError(<value>)
Return custom value in the case of error
fallbackOnError(<value>, <fallback>)
Rounding functions
Round functions are available to round stored or calculated number values based on specific criteria or mathematical procedures.
roundLong
roundLong(<value>)
roundLongHalfAwayFromZero
roundLongHalfAwayFromZero(<value>)
roundLongHalfEven
roundLongHalfEven(<value>)
roundLongHalfUp
roundLongHalfUp(<value>)
roundLongHalfDown
roundLongHalfDown(<value>)
round
round(<value>, <scale>)
roundHalfAwayFromZero
roundHalfAwayFromZero(<value>, <scale>)
roundHalfEven
roundHalfEven(<value>, <scale>)
roundHalfUp
roundHalfUp(<value>, <scale>)
roundHalfDown
roundHalfDown(<value>, <scale>)
Case differentiation
To 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, a result of a formula is used, otherwise a static value 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. This means that a calculation can only be carried out if, for example, the associated order has a certain status.
//Read an order status
case(equalsIgnoreCase(rowDataField("062FA7D7B2F1651C5037307B0E3E1FB2B107969F", ""), "Bestellt"), true, false)
Case
case(<booleanExpression>, <trueExpression>, <falseExpression>)
Case not
caseNot(<booleanExpression>, <trueExpression>, <falseExpression>)
Boolean expressions
Equal to
equals(<string1>, <string2>)
Equal to (ignore case)
equalsIgnoreCase(<string1>, <string2>)
Starts with
startsWith(<string>, <prefix>)
Starts with (ignore case)
startsWithIgnoreCase(<string>, <prefix>)
Ends with
endsWith(<string>, <suffix>)
Ends with (ignore case)
endsWithIgnoreCase(<string>, <suffix>)
Contains
contains(<string>, <sequence>)
Contains (ignore case)
containsIgnoreCase(<string>, <sequence>)
Test for empty string
isEmpty(<string>)
Test for empty string or null value
isNullOrEmpty(<string>)
Test for null value
isNull(<value>)
Mathematical
Absolute value
abs(<value>)
Table functions
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):
//Determination of the sum of all data currently displayed
sum(table("TABLE_GUID"), row("CONTROL_GUID"))
//Determination of the sum of all data from page 1 of the table to the displayed page
//Differs from sum only if there is a table navigation and you are no longer on the first page
subTotalSum(table("TABLE_GUID"), row("CONTROL_GUID"))
//Sum over all records displayed in the table, regardless of the current position of the navigation element
totalSum(table("TABLE_GUID"), row("CONTROL_GUID"))
Analogous methods are available for:
Maximum value
max/subTotalMax/totalMax
Minimum value
min/subTotalMin/totalMin
Number
count/subTotalCount/totalCount
Average value
avg/subTotalAvg/totalAvg
Please note that the total methods are computation-intensive operations. If very large volumes of data are involved, delays may occur.
Column values of records (current view)
Sum
Subtotal from control
Determination of the sum of all data currently 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>))
Sum from calculation
sum(table("<tableGuid>"), rowFormula("<tableFormulaGuid>"))
sum(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
sum(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
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>))
Child data records
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>)))
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>)))
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>)))
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>)))
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>)))
Maximum
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>))
Maximum from calculation
max(table("<tableGuid>"), rowFormula("<tableFormulaGuid>"))
max(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
max(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
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>))
Child data records
Minimum 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>)))
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>)))
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>)))
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>)))
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>)))
Minimum
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>))
Minimum from calculation
min(table("<tableGuid>"), rowFormula("<tableFormulaGuid>"))
min(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
min(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
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>))
Child data records
Minimum 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>)))
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>)))
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>)))
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>)))
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>)))
Number
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>))
Number from calculation
count(table("<tableGuid>"), rowFormula("<tableFormulaGuid>"))
count(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
count(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
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>))
Child data records
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>)))
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>)))
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>)))
Number of maxima 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>)))
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>)))
Average value
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>))
Average value from calculation
avg(table("<tableGuid>"), rowFormula("<tableFormulaGuid>"))
avg(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
avg(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
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>))
Child data records
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>)))
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>)))
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>)))
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>)))
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>)))
Column values of records (subtotal)
Sum
Subtotal 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>))
Sum from calculation
subTotalSum(table("<tableGuid>"), rowFormula("<tableFormulaGuid>"))
subTotalSum(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
subTotalSum(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
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>))
Child data records
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>)))
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>)))
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>)))
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>)))
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>)))
Maximum
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>))
Maximum from calculation
subTotalMax(table("<tableGuid>"), rowFormula("<tableFormulaGuid>"))
subTotalMax(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
subTotalMax(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
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>))
Child data records
Minimum 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>)))
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<)))
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>)))
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>)))
Maximum of average values of child records
Minimum
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>))
Minimum from calculation
subTotalMin(table("<tableGuid>"), rowFormula("<tableFormulaGuid>"))
subTotalMin(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
subTotalMin(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
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>))
Child data records
Minimum 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>)))
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>)))
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>)))
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>)))
Minimum of average values of child records
Number
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>))
Number from calculation
subTotalCount(table("<tableGuid>"), rowFormula("<tableFormulaGuid>"))
subTotalCount(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
subTotalCount(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
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>))
Child data records
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>)))
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>)))
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>)))
Number of maxima 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>)))
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>)))
Average value
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>))
Average value from calculation
subTotalAvg(table("<tableGuid>"), rowFormula("<tableFormulaGuid>"))
subTotalAvg(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
subTotalAvg(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
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>))
Child data records
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>)))
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>)))
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>)))
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>)))
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>)))
Column values of all records
Sum
Subtotal 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>))
Sum from calculation
totalSum(table("<tableGuid>"), rowFormula("<tableFormulaGuid>"))
totalSum(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
totalSum(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
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>))
Child data records
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>)))
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>)))
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>)))
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>)))
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>)))
Maximum
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>))
Maximum from calculation
totalMax(table("<tableGuid>"), rowFormula("<tableFormulaGuid>"))
totalMax(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
totalMax(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
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>))
Child data records
Minimum 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>)))
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>)))
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>)))
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>)))
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>)))
Minimum
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>))
Minimum from calculation
totalMin(table("<tableGuid>"), rowFormula("<tableFormulaGuid>"))
totalMin(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
totalMin(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
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>))
Child data records
Minimum 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>)));))
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>)))
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>)))
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>)))
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>)))
Number
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>))
Number from calculation
totalCount(table("<tableGuid>"), rowFormula("<tableFormulaGuid>"))
totalCount(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
totalCount(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
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>))
Child data records
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>)))
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>)))
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>)))
Number of maxima 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>)))
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>)))
Average value
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>))
Average value from calculation
totalAvg(table("<tableGuid>"), rowFormula("<tableFormulaGuid>"))
totalAvg(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
totalAvg(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
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>))
Child data records
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>)))
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>)))
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>)))
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>)))
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>)))
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.
Functions for single date values
If a value is to be determined from a single date value, the following methods can be used as shown in the example. For all methods, the time zone to be used can be stated as the second parameter.
//Hour portion of the current date in the Europe/Berlin time zone
hour(currentDateTime, "Europe/Berlin")
//Day of the month from a date value of a data field without time zone specification
//Thus the time zone of the currently logged in user is taken into account
dayOfMonth(dataField("2DA5429B4BE959EBE28B18E0BAB8C4705C789D1A", -1))
Day of year
Day of the year.
dayOfYear("<dateExpression>", "<timeZone>")
dayOfYear("<dateExpression>")
dayOfYear("<dateExpression>", "<timeZone>")
Day of month
Day of the month.
dayOfMonth("<dateExpression>", "<timeZone>")
dayOfMonth("<dateExpression>")
dayOfMonth("<dateExpression>", "<timeZone>")
Day of week
Day of the week with Monday as the start of the week.
dayOfWeek("<dateExpression>", "<timeZone>")
dayOfWeek("<dateExpression>")
dayOfWeek("<dateExpression>", "<timeZone>")
Week of year (week starts on Monday)
Week of the year with Monday as the start of the week.
weekOfYear("<dateExpression>", "<timeZone>")
weekOfYear("<dateExpression>")
weekOfYearISO("<dateExpression>", "<timeZone>")
weekOfYearISO("<dateExpression>")
weekOfYear("<dateExpression>", "<timeZone>")
Week of year (week starts on Sunday)
Week of the year with Sunday as the start of the week.
weekOfYearSunday("<dateExpression>", "<timeZone>")
weekOfYearSunday("<dateExpression>")
weekOfYearSunday("<dateExpression>", "<timeZone>")
Year
Year of the date.
year("<dateExpression>", "<timeZone>")
year("<dateExpression>")
year("<dateExpression>", "<timeZone>")
Month
Month of the date (January = 1, Feburary = 2, ...)
month("<dateExpression>", "<timeZone>")
month("<dateExpression>")
month("<dateExpression>", "<timeZone>")
Hour
Hour of the date.
hour("<dateExpression>", "<timeZone>")
hour("<dateExpression>")
hour("<dateExpression>", "<timeZone>")
Minute
Minutes of the date
minute("<dateExpression>", "<timeZone>")
minute("<dateExpression>")
minute("<dateExpression>", "<timeZone>")
Second
Seconds of the date
second("<dateExpression>", "<timeZone>")
second("<dateExpression>")
second("<dateExpression>", "<timeZone>")
Millisecond
Milliseconds of the date.
millisecond("<dateExpression>", "<timeZone>")
millisecond("<dateExpression>")
millis("<dateExpression>", "<timeZone>")
millis("<dateExpression>")
millisecond("<dateExpression>", "<timeZone>")
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)
Difference in days
Different between two date values in days.
diffInDay("<dateExpression1>", "<dateExpression2>")
Difference in hours
Different between two date values in hours.
diffInHour("<dateExpression1>", "<dateExpression2>")
Difference in minutes
Different between two date values in minutes.
diffInMinute("<dateExpression1>", "<dateExpression2>")
Difference in seconds
Different between two date values in seconds.
diffInSecond("<dateExpression1>", "<dateExpression2>")
Difference in milliseconds
Different between two date values in milliseconds.
diffInMillisecond("<dateExpression1>", "<dateExpression2>")
Date expressions
In the same way as number values, date values can also be read from data fields, rows in tables etc.
Date from current record
Date from control
Date value from a control.
controlAsDateTime("<controlGuid>")
controlAsDateTime("<controlGuid>", <fallbackValue>)
controlAsDateTime("<controlGuid>", <fallbackValue>)
Date from data field
Date value from a data field.
dataFieldAsDateTime("<dataFieldGuid>")
dataFieldAsDateTime("<dataFieldGuid>", <fallbackValue>)
dataFieldAsDateTime("<dataFieldGuid>", <fallbackValue>)
Date from table
Date from current row
Date from control
Date value from the current row in a view table.
rowAsDateTime("<tableControlGuid>")
rowAsDateTime("<tableControlGuid>", <fallbackValue>)
rowAsDateTime("<tableControlGuid>", <fallbackValue>)
Date from data field
Date value from the current row per data field GUID in a view table.
rowDataFieldAsDateTime("<tableDataFieldGuid>")
rowDataFieldAsDateTime("<tableDataFieldGuid>", <fallbackValue>)
rowDataFieldAsDateTime("<tableDataFieldGuid>", <fallbackValue>)
Date from system value
Date from session value
Date value from a session variable.
sessionAsDateTime("<variable>")
sessionAsDateTime("<variable>", <fallbackValue>)
sessionAsDateTime("<variable>", <fallbackValue>)
Date from processing context
Date value from a variable from the current processing context.
sharedStateAsDateTime("<variable>")
sharedStateAsDateTime("<variable>", <fallbackValue>)
sharedStateAsDateTime("<variable>", <fallbackValue>)
Date from request value
Date value from a request variable.
requestAsDateTime("<variable>")
requestAsDateTime("<variable>", <fallbackValue>)
requestAsDateTime("<variable>", <fallbackValue>)
Date from system data group
Date value from the value of a system data field.
systemFieldAsDateTime("<systemFieldGuid>")
systemFieldAsDateTime("<systemFieldGuid>", <fallbackValue>)
systemFieldAsDateTime("<systemFieldGuid>", <fallbackValue>)
Date from string value
Date value from a string.
dateTime("<dateTimeString>", "<dateTimeFormat>", "<timeZone>")
dateTime("<dateTimeString>", "<dateTimeFormat>")
e.g. dateTime("2014-01-01T12:00:00Z", "yyyy-MM-dd'T'HH:mm:ss'Z'", "UTC")
dateTime("<dateTimeString>", "<dateTimeFormat>", "<timeZone>")
Current date
The current date.
currentDateTime
Current date from request
Returns the date from the last request.
currentRequestDateTime
Send us an e-mail