General Information
Formulas can be used to create calculative forms in Intrexx applications. Calculations can be defined using the "Calculation" element as well as in the column properties of view tables, for example, to display totals or cumulative values below the table. Calculations can also be performed within table rows and columns.
Intrexx Formula Collection
In the Formula Editor, you can access the Intrexx formula library in the "Libraries" section. Once you've selected an item in the library, you'll see the following buttons in the lower-right corner:
View description
Here you will find a description of the currently selected function, along with a sample script.
Open link
Provides links to relevant pages with additional information.
Operators
Formulas are based on mathematical operators that can be used to perform standard calculations such as addition and subtraction. There are also logical operators.
Logical operators return double values, not Boolean values. 1.00 represents true, and 0.00 represents false.
Arithmetic
Addition
+Subtraction
-Multiplication
*
Division
/
Comparison
Smaller than
<
Greater than
>
Less than or equal to
<=
Greater than or equal to
>=
Is Equal To
==
Is Unequal
!=
Logical
"AND" Operator
In an "AND" condition, all values must meet the criteria.
&&
"OR" Operator
In an OR condition, at least one value must meet the criteria.
||
Negation
Returns all values that do not meet the criteria.
!
Values
On application pages, values from various sources—such as elements (controls) or data groups—can be retrieved in formulas. 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 available methods are described below.
Value from the current data record
Value from the check
Reading a value from a control of type Integer or Double with a fallback value of 0.
control("<controlGuid>")
control("<controlGuid>", <fallbackValue>)
control("<controlGuid>", <fallbackValue>)
Value from check (type: string)
Reading a numeric value from a string-type control with a fallback value of 0.
controlAsNumber("<controlGuid>")
controlAsNumber("<controlGuid>", <fallbackValue>)
controlAsNumber("<controlGuid>", <fallbackValue>)
Value from calculation
Reading the contents of another calculation check. Please be careful not to define circular references between calculation checks.
formula("<formulaGuid>")
formula("<formulaGuid>", <fallbackValue>)
formula("<formulaGuid>", <fallbackValue>)
Value from data field
Retrieving a value based on the GUID of the desired data field.
dataField("<dataFieldGuid>")
dataField("<dataFieldGuid>", <fallbackValue>)
dataField("<dataFieldGuid>", <fallbackValue>)
Value from data field (string type)
Retrieve a numeric value of type String based on the GUID of the desired data field.
dataFieldAsNumber("<dataFieldGuid>")
dataFieldAsNumber("<dataFieldGuid>", <fallbackValue>)
dataFieldAsNumber("<dataFieldGuid>", <fallbackValue>)
Child Records
Various aggregate functions can be applied to child records in the current dataset. Example:
//Calculation of the sum of a data field from the child data group
childSum(dataGroup("669F2C0747A5FFBB4FB2C7829945071E1ED5B0CB"), dataField("9AA6E0484980D633B43DB53D9B11AF22962667B4", 0))Total number of child records
The sum of a data field across all child 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>))
Minimum number of child records
The minimum value of a data field across all child records of the current parent record in the child data group.
childMin(dataGroup("<dataGroupGuid>"), dataField("<dataFieldGuid>", <fallbackValue>))
childMin(dataGroup("<dataGroupGuid>"), dataFieldAsNumber("<dataFieldGuid>", <fallbackValue>))
childMin(dataGroup("<dataGroupGuid>"), dataField("<dataFieldGuid>", <fallbackValue>))
Maximum number of child records
The maximum value of a data field across all child records of the current parent record in 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
Calculate the number of child records associated with the current parent record.
childCount(dataGroup("<dataGroupGuid>"), dataField("<dataFieldGuid>", <fallbackValue>))
childCount(dataGroup("<dataGroupGuid>"), dataFieldAsNumber("<dataFieldGuid>", <fallbackValue>))
childCount(dataGroup("<dataGroupGuid>"), dataField("<dataFieldGuid>", <fallbackValue>))Average value of the child records
Calculate the average value of a data field across all child records associated with the current parent record.
childAvg(dataGroup("<dataGroupGuid>"), dataField("<dataFieldGuid>", <fallbackValue>))
childAvg(dataGroup("<dataGroupGuid>"), dataFieldAsNumber("<dataFieldGuid>", <fallbackValue>))
childAvg(dataGroup("<dataGroupGuid>"), dataField("<dataFieldGuid>", <fallbackValue>))
Value from table
In view tables, calculation checks can be defined as a new column. This allows the stored formula to be executed for each row of the table. 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 the current row
Value from the check
Accessing a column value with a fallback value.
row("<tableControlGuid>")
row("<tableControlGuid>", <fallbackValue>)
row("<tableControlGuid>", <fallbackValue>)
Value from check (type: string)
Accessing a column value of type string with a fallback value.
rowAsNumber("<tableControlGuid>")
rowAsNumber("<tableControlGuid>", <fallbackValue>)
rowAsNumber("<tableControlGuid>", <fallbackValue>)
Value from calculation
Accessing a column formula with a fallback value.
rowFormula("<tableFormulaGuid>")
rowFormula("<tableFormulaGuid>", <fallbackValue>)
rowFormula("<tableFormulaGuid>", <fallbackValue>)
Value from data field
Accessing a column value using the data field GUID with a fallback value.
rowDataField("<tableDataFieldGuid>")
rowDataField("<tableDataFieldGuid>", <fallbackValue>)
rowDataField("<tableDataFieldGuid>", <fallbackValue>)
Value from data field (string type)
Accessing a column value with a fallback value.
rowDataFieldAsNumber("<tableDataFieldGuid>")
rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>)
rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>)
Child Records
If child data groups exist for the current data group, you can also access the child records of the current record and perform various aggregate functions 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))
Total number of child records
The sum of a data field across all child 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>))
Minimum number of child records
The minimum value of a data field across all child records of the current parent record in the child data group.
childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
childMin(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))
childMin(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
Maximum number of child records
The maximum value of a data field across all child records of the current parent record in 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
Calculate the number of child records associated with the current parent record.
childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
childCount(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))
childCount(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
Average value of the child records
Calculate the average value of a data field across all child records associated with the current parent record.
childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
childAvg(dataGroup("<tableDataGroupGuid>"), rowDataFieldAsNumber("<tableDataFieldGuid>", <fallbackValue>))
childAvg(dataGroup("<tableDataGroupGuid>"), rowDataField("<tableDataFieldGuid>", <fallbackValue>))
Value from the overall calculation
Value from calculation
formula("<tableFormulaGuid>")
formula("<tableFormulaGuid>", <fallbackValue>)
formula("<tableFormulaGuid>", <fallbackValue>)
System value
In addition to values from data sets, formulas can access various system values, such as data from sessions or system data groups.
//Reading a value from a system data group
//Specify the data field name
systemField(("L_VERSION"), 0)
Session value
Reading a value from the user session.
session <variable>>")
session("<variable>", <fallbackValue>)
session("<variable>", <fallbackValue>)
Session value (type: String)
Reading a value of type String from the user session.
sessionAsNumber("<variable>")
sessionAsNumber("<variable>", <fallbackValue>)
sessionAsNumber("<variable>", <fallbackValue>)
Value from the processing context
Retrieve a value from the current processing context.
sharedState("<variable>")
sharedState("<variable>", <fallbackValue>)
sharedState("<variable>", <fallbackValue>)Value from the processing context (type: String)
Retrieve a value of type String from the current processing context.
sharedStateAsNumber("<variable>")
sharedStateAsNumber("<variable>", <fallbackValue>)
sharedStateAsNumber("<variable>", <fallbackValue>)Request Value
Retrieving a value from the current request.
requestAsNumber("<variable>")
requestAsNumber("<variable>", <fallbackValue>)
requestAsNumber("<variable>", <fallbackValue>)
Value from system data group
Reading a value from a system data group.
systemField("<variable>")
systemField("<variable>", <fallbackValue>)
systemField("<variable>", <fallbackValue>)
Value from system data group (type: string)
Reading a value of type String from a system data group.
systemFieldAsNumber("<variable>")
systemFieldAsNumber("<variable>", <fallbackValue>)
systemFieldAsNumber("<variable>", <fallbackValue>)
null
null
true
true
false
false
Features
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 (null). However, server errors that occur during the calculation are not addressed. This can be the case, for example, when a value from a string data field is to be used in a formula, but that value cannot be parsed as a number. This is the case for all non-numeric characters. In these situations, the calculation check displays only "An error has occurred" instead of a value. In some cases, this may be desirable in order to identify incorrect data directly. However, if this is not desired, such server errors can be restarted 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)
Returns 0 in the event of an error
zeroOnError(<value>)
Return 1 if an error occurs
oneOnError(<value>)
Returning a user-defined value in the event of an error
fallbackOnError(<value>, <fallback>)Rounding Functions
Various rounding methods are available for rounding stored or calculated numerical values according to 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 Distinctions
To perform even more complex calculations or formulas only under certain conditions, you can define case distinctions.
//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 numeric values, strings can also be evaluated in a Boolean expression. This means that a calculation can only be performed if, for example, the associated purchase order has a specific status.
//Read an order status
case(equalsIgnoreCase(rowDataField("062FA7D7B2F1651C5037307B0E3E1FB2B107969F", ""), "Bestellt"), true, false)
If
case(<booleanExpression>, <trueExpression>, <falseExpression>)
If not
caseNot(<booleanExpression>, <trueExpression>, <falseExpression>)
Boolean Expressions
Right away
equals(<string1>, <string2>)
Equal (ignore case)
equalsIgnoreCase(<string1>, <string2>)
Begins 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>)
Check for an empty string
isEmpty(<string>)
Check for an empty string or a null value
isNullOrEmpty(<string>)
Test for a value of zero
isNull(<value>Mathematically
Absolute value
abs(<value>Table Functions
Aggregate Functions for Column Values
Below tables, it is often necessary to determine the values to be displayed in the table. These include calculations such as totals, subtotals, and averages. There are three different variants for this, designed to cover various use cases (shown here using the example of calculating a sum):
//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"))
Analog methods exist 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 involve computationally intensive operations. With very large datasets, delays may occur.
Column values of the records (current view)
Total
Total from audit
Calculate 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>))
Total from calculation
sum(table("<tableGuid>"), rowFormula("<tableFormulaGuid>"))
sum(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
sum(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
Sum of 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 Records
Sum of the sums of the 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 the minimum values of the 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 the maximum values in the 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>)))
Total 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 the average values of the 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 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 the 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 Records
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>)))Maximum of the minima of the 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 the maxima of the 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 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 the averages of the 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 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 the 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 Records
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>)))
Minimum of the minimums of the 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 the maxima of the 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 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 the averages of the 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 the control group
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>))
Count 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 Records
Number of 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 in the 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 in the 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 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 averages of the 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 the control group
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 calculated
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 Records
Average of the Sums of the 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 of the minimum values of the 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 of the maximum values of the 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 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 of the averages of the 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 the data records (subtotal)
Total
Total from audit
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>))
Total from calculation
subTotalSum(table("<tableGuid>"), rowFormula("<tableFormulaGuid>"))
subTotalSum(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
subTotalSum(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
Sum of 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 Records
Sum of the sums of the 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 the minimum values of the 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 the maximum values in the 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>)))Total 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 the average values of the 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 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 the 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 Records
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>)))Maximum of the minima of the 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 the maxima of the 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 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 the averages of the child records
Minimum
Minimum 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 the 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 Records
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>))Minimum of the minimums of the 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 the maxima of the 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 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 the averages of the child records
Number
Number from the control group
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>))
Count 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 Records
Number of 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 in the 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 in the 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 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 averages of the 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 the control group
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 calculated
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 Records
Average of the Sums of the 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 of the minimum values of the 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 of the maximum values of the 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 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 of the averages of the 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 for all records
Total
Total from audit
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>))
Total from calculation
totalSum(table("<tableGuid>"), rowFormula("<tableFormulaGuid>"))
totalSum(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
totalSum(table("<tableGuid>"), rowFormula("<tableFormulaGuid>", <fallbackValue>))
Sum of 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 Records
Sum of the sums of the 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 the minimum values of the 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 the maximum values in the 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>)))
Total 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 the average values of the 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 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 the 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 Records
Maximum of the sums of the 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 the minima of the 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 the maxima of the 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 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 the averages of the 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 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 the 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 Records
Maximum of the sums of the 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 the minimums of the 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 the maxima of the 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 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 the averages of the 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 the control group
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>))
Count 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 Records
Number of 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 in the 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 in the 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 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 averages of the 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 the control group
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 calculated
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 Records
Average of the Sums of the 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 of the minimum values of the 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 of the maximum values of the 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 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 of the averages of the 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
Date and time values can be used to determine deadlines, due dates, and similar scenarios. This includes both system data, such as the creation date, and values from date and time fields or the current time.
Functions for Individual Date Values
If you need to calculate a value based on a single date, you can use the following methods, as shown in the example. For all methods, the time zone to be used can be specified 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 the year
Day of the Year.
dayOfYear("<dateExpression>", "<timeZone>")
dayOfYear("<dateExpression>")
dayOfYear("<dateExpression>", "<timeZone>")
Day of the month
Day of the month.
dayOfMonth("<dateExpression>", "<timeZone>")
dayOfMonth("<dateExpression>")
dayOfMonth("<dateExpression>", "<timeZone>")
Day of the week
Day of the week, with Monday as the first day of the week.
dayOfWeek("<dateExpression>", "<timeZone>")
dayOfWeek("<dateExpression>")
dayOfWeek("<dateExpression>", "<timeZone>")
Week of the year (week begins 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>")
Week of the year (week begins on Sunday)
Week of the year, with Sunday as the first day 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, February = 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 difference 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
The difference between two date values in days.
diffInDay("<dateExpression1>", "<dateExpression2>")
Difference in hours
The difference between two date values in hours.
diffInHour("<dateExpression1>", "<dateExpression2>")
Difference in minutes
The difference between two date values in minutes.
diffInMinute("<dateExpression1>", "<dateExpression2>")
Difference in seconds
The difference between two date values in seconds.
diffInSecond("<dateExpression1>", "<dateExpression2>")
Difference in milliseconds
The difference between two date values in milliseconds.
diffInMillisecond("<dateExpression1>", "<dateExpression2>")
Date Expressions
Just as with numeric values, date values can also be retrieved from data fields, rows in tables, etc.
Date from the current data record
Date from inspection
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 the current row
Date from inspection
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, identified by the 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 the processing context
Date value from a variable in 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 derived from the value of a system data field.
systemFieldAsDateTime("<systemFieldGuid>")
systemFieldAsDateTime("<systemFieldGuid>", <fallbackValue>)
systemFieldAsDateTime("<systemFieldGuid>", <fallbackValue>)
Date from a 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 the request
The date from the last request.
currentRequestDateTime