I've got a record set of ledger lines. This produces multiple lines for each record. I used min() calculations on my ledger amounts... insurance paid, client paid, total paid, etc. and that works for the individual lines, but this method doesn't allow me to get accurate totals.
What would be a simple method of being able to pare down the multiple lines and also get an accurate sum total for each column.