YTD Totals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that calculates monthly totals ( which works fine), I need to
calclulate a YTD total also. Can someone help with this.

Thank You
 
Place this in an unbound box at the end after your monthly totals:
=SUM([Jan]+[Feb]+...+[Dec])

Adjust the Jan, Feb, Dec with whatever you called your variables.

If you want totals per month, you'd have to create in the footer of the year
another unbound box where you have,

=SUM([Jan])

then you can do a grand total doing a sum over those boxes.

Hope that helps,
Tim
 
Back
Top