YTD Totals

[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

 

[Guest]

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