Total of sums

  • Thread starter Thread starter George
  • Start date Start date
G

George

Hi,

I would like a report that totals firstly each clients cashflows for the
month and secondly totals the every cashflow across all clients for the
period.
I seem to be able to list each clients name and their net cashflows (using
the expression "=Sum(GrossAmount)") for the period but the second total
adding each of these net amounts up i am having trouble with.

Any ideas?

Thanks
George
 
George said:
I would like a report that totals firstly each clients cashflows for the
month and secondly totals the every cashflow across all clients for the
period.
I seem to be able to list each clients name and their net cashflows (using
the expression "=Sum(GrossAmount)") for the period but the second total
adding each of these net amounts up i am having trouble with.
Click to expand...

You can use the exact same expression in a text box in the
period group footer section.

If you want a grand total across all periods in the report
use the same thing again in the Report Footer section.
 
Back
Top