Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
How to Group Payment Transactions Based on Running Total in Oracle BI Publisher E-Text Template?
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:
1