Sum distinct rows
Hi there, it is me again. I created a related table that saves all issues that one ID can have in time, so this table generate a row different row, every time that a issue is informed. After that, i ...
Forum Discussion
It sounds like the price is a lookup from the ID record down to the issue records.
If that is the case, then simply make your report or chart based in the Average Price and not in the Sum of the Price. Every Price lookup for an Issue is identical, so the average will just be an average of identical numbers and not double or triple count.
If that is the case, then simply make your report or chart based in the Average Price and not in the Sum of the Price. Every Price lookup for an Issue is identical, so the average will just be an average of identical numbers and not double or triple count.