|Aggregation Issue on a Group - getting repetition [message #1797926]
||Thu, 08 November 2018 15:47
| Ariane Ben-Oliel
Registered: May 2018
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.03067 seconds