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 article 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
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for