Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
The Average()
function calculates the average of a list of numbers, date times or duration.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns number, datetime or duration that is the average of the given values
.
Returns Unknown
if one of the parameter values is unknown or outside the common valid boundaries.
Name | Type | Required | Description |
---|---|---|---|
values
list of numbers datetimes or durations.
The list of values for which the average is calculated. The values can be either numbers, datetimes or durations.
The First()
function returns the first item in a list or concept set.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns the first item in the given list
or concept_set
.
Returns Unknown
if one of the parameter values is unknown or outside the common valid date boundaries.
Name | Type | Required | Description |
---|---|---|---|
list
List of elements of the same type
a list of values or elements of the same type.
concept_set
A list of concepts
a list of concepts
The Last()
function returns the last item in a list or concept set.
For (persistent) lists it must indicate a field of that list.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns the last item in the given list
or concept_set
.
Returns Unknown
if one of the parameter values is unknown or outside the common valid date boundaries.
Possible fault message in expression editor: Invalid call to a function: parameter mismatch at position(x,y): Last
This could mean that there is no field of list used, but only the (reference to a) list.
The Last function needs a field from list where filter construction, or if you only want to get the last row of a list, use RowId([list]) of [list] where [filter]
.
Name | Type | Required | Description |
---|---|---|---|
values
list or a concept_set
a collection of values or elements of the same type, or a list of fields from a (persistent) list.
The Min()
function calculates the lowest value of a list of numbers, datetimes or durations.
This function is SQL compatible. For more information about SQL compatibility, see our documentation.
Returns a number, datetime or duration that is the lowest value of the given values
.
Returns Unknown
if one of the parameter values is unknown or outside the common valid date boundaries.
Name | Type | Required | Description |
---|---|---|---|
values
list
list of values which can be either numbers, datetimes or durations.
The Sum()
function calculates the total value of a list of numbers or durations.
This function is SQL compatible. For more information about SQL compatibility, see our documentation.
Returns a number or duration that is the total value of the given values
.
Returns Unknown
if one of the parameter values is unknown or outside the common valid date boundaries.
Name | Type | Required | Description |
---|---|---|---|
values
list
the list of values of which the sum is calculated. The values can be either numbers or durations.
This function is SQL compatible. For more information about SQL compatibility, see our .
Name | Type | Required | Description |
---|
| List of elements of the same type | a list of values or elements of the same type. |
| A list of concepts | a list of concepts |
The Max()
function calculates the highest value of a list of numbers, datetimes or durations.
This function is SQL compatible. For more information about SQL compatibility, see our documentation.
Returns a number, datetime or duration that is the highest value of the given values
.
Returns Unknown
if one of the parameter values is unknown or outside the common valid date boundaries.
Name | Type | Required | Description |
---|---|---|---|
values
list
the list of values. The values can be either numbers, datetimes or durations.