cheyennemtnman
Member
I have a list that uses a Join element which I am grouping by that has summing of two columns by the grouping.
When there are two entries in the joined element's table, it doubles the sum of details in the listing because of the two entries in the joined table.
If I deleted the second entry in the joined table, then sums added up correctly.
To prevent this, I validated the element used to join the lists to be unique, which solved the problem.
Why did the one list with the summed columns run through the sum routine twice? Should this happen?
When there are two entries in the joined element's table, it doubles the sum of details in the listing because of the two entries in the joined table.
If I deleted the second entry in the joined table, then sums added up correctly.
To prevent this, I validated the element used to join the lists to be unique, which solved the problem.
Why did the one list with the summed columns run through the sum routine twice? Should this happen?
Last edited: