1 Reply Latest reply on Sep 11, 2018 9:08 AM by Deepak Rai

    Multiple lines per record...Totals help.

    Paul Brainard

      Good Day fine people,

       

      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.

       

      Please and thank you,

       

      Paul