Hello All,
I am using Electronic Reporting to generate an Output File comprising of Vendor Payments. Info being gathered from Vendor Payment Journals and lines. LedgerJournalTrans being used as main datasource for all the Lines/Details records in the Text Output file. Below is a snippet of the Format Designer and Model Mapping : LedgerJournalTrans Record List, and an Enumeration of that Record List is what is comprising of my recursive DetailRecords Sequence in the file. However, in the Trailer Record, I need to sum up the values of all the Debit Payments from the Lines. Sum of the values in AmountCurDebit column from the entire record list returned from LedgerJournalTrans. I am trying to use SUMIF() ER Function, but it is asking as arguments...some Collected data key name . On none of the Sequence control or other String controls did I find this Collected Data Key Name property. So not sure what it is. What exactly should I be passing to the SUMIF() function to get my total?Thank you.
You can use the SUM() function in a "Group by" element. You're not forced to choose any fields to group by, therefore the aggregation will include all records.
You can configure the collector data key name in properties of a sequence.
You'll see both approaches in Example: Defer the execution of a sequence element in an ER format.
Thank you Martin. That is very helpful. I was able to create a Group By on the Record List and inside the Edit Group By window was able to do a SUM function on the specific field.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 683 Most Valuable Professional
André Arnaud de Cal... 563 Super User 2025 Season 2
Sohaib Cheema 398 User Group Leader
