LBASS,
Thanks for getting back to me.
I've been away and just getting back to work.
If I create the formula in the report footer
if year(table.date) = 2008 then sum(table.amount)
the formula sums ALL values, not just those for 2008.
I can get the correct sum for each year using a running total...
I need to show data in two columns, Grouped by Year, Month, Day and Hour
2008 2007 Variance
Group Header 1: Total 500 400 100
Group Header 2 Month
Jan 300 150...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.