I've got two columns I'm trying to compare on my report, and only return records where there's a difference. This will allow the user to see inconsistencies.
The first column is one - to - one with the main table, and the other column is a one - to - many with the main table, and I have to divide this second column by 1000 in order to compare the two.
I can visually see the dollar amounts are the same (or different), but can't get the report to see that. Both totals are per PK in the main table. The first column is simply the value of the column, where the second is the summation / 1000.