List of ER functions in the data collection category

Electronic reporting (ER) data collection functions are used to do counting and summing in an ER format that is being run, based on data of the output that has already been generated in Text or Xml format. This approach is used to help improve performance of an ER format that is run, to enter values of running totals in generated documents, and for other purposes. This topic provides a summary of these functions.

List of supported functions

Function Description
CollectedList This function returns a Record list value that contains the list of values that were returned by the Collected data key value property of format elements and collected when the format elements were used to generate an outbound document during the format run, and that satisfies the specified conditions. Each condition consists of a key range and a key value.
CountIF This function returns an Integer value that represents the number of format elements that was collected when the format elements were used to generate an outbound document during the format run, and that satisfies the specified condition. The condition consists of a key range and a key value.
CountIFs This function returns an Integer value that represents the number of format elements that was collected when the format elements were used to generate an outbound document during the format run, and that satisfies the specified conditions. Each condition consists of a key range and a key value.
FormatElementName This function returns a String value that represents the name of the current ER format's element.
SumIF This function returns a Real value that represents the sum of values that were returned by bindings of format elements and collected when the format elements were used to generate an outbound document during the format run, and that satisfies the specified condition. The condition consists of a key range and a key value.
SumIFs This function returns a Real value that represents the sum of values that were returned by bindings of format elements and collected when the format elements were used to generate an outbound document during the format run, and that satisfies the specified conditions. Each condition consists of a key range and a key value.

Additional resources

Electronic Reporting overview

Formula designer in Electronic reporting

Electronic reporting formula language