Good morning all! I have a Statement report with a subreport for member accounts. The sub report has running sum set to "over group". For those that have more than one line item, it is calculating incorrectly on SOME records. Images attached. The subreport is based on a table, so nothing fancy there. It is grouped by the member ID, the calculated balance field is: =Nz([dbamount],0)-Nz([CRAmount],0). The grand total calculation is: =Nz([totaldbamount],0)-Nz([totalcramount],0).
Thanks in advance as always!