Is there a way to compare the SUM of the lines on a bill payment against an AVERAGE total amount in a SQL?
I have a save search grouped by Tranaction # with column #1 being the SUM of the {appliedtolinkamount} and Col#2 being an AVERAGE of the {amount}. I would like to only show bill payments when these values are not equal, but I am not sure how to do that.