Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Newcomers » Newcomers » Aggregation Issue on a Group - getting repetition(Aggregation Issue on a Group - getting repetition)
Aggregation Issue on a Group - getting repetition [message #1797926] Thu, 08 November 2018 15:47
Ariane Ben-Oliel is currently offline Ariane Ben-OlielFriend
Messages: 1
Registered: May 2018
Junior Member
Here is my issue:

I have created a table with one group - a contract ID. For every contract, I am getting lines for multiple payment line items.

I am trying to aggregate outside of the table (at the end of my report) on a number field - this field exists on the contract (the parent record). However, my aggregation is summing this field for every payment line item on the contract, not just the contract itself - resulting in an incorrect total.

Is there a solution to look at this field only once per contract (and not for every payment line item)?

i.e. if this field is $500 on a contract, I am returning $1500 for the contract because it has 3 payment line items. I want to look at this field only once per contract, and then sum the total of this field for all contracts.

Thanks in advance.
Previous Topic:FileNotFoundException: javax.inject_1.0.0.v20091030.jar
Next Topic:Missing Web Tools on Eclipse for Java
Goto Forum:

Current Time: Thu Nov 15 16:23:25 GMT 2018

Powered by FUDForum. Page generated in 0.03067 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top