Aggregation Issue on a Group - getting repetition [message #1797926] |
Thu, 08 November 2018 15:47 |
Ariane Ben-Oliel 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.
|
|
|
Powered by
FUDForum. Page generated in 0.08044 seconds