How to Group Payment Transactions Based on Running Total in Oracle BI Publisher E-Text Template? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to Group Payment Transactions Based on Running Total in Oracle BI Publisher E-Text Template?

edited Apr 15, 2025 7:35AM in Reporting and Analytics for HCM 1 comment

Hi everyone,

I’m working on an E-Text Template in Oracle BI Publisher for a payment file, and I’m trying to group transactions based on a running total. The goal is to break or group records when the running total reaches a certain amount (e.g., 10,00,000 $), and then start a new group.

Here’s what I need help with:

Is it possible to calculate and reset a running total inside the E-Text template?

Can I create a group break or conditional logic in the template based on the running total?

Are there any best practices or sample code snippets that could help achieve this?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!