I have a gridview report I am building to display sales information for customers in a certain territory. The report displays the sales information, but when I summarize (sorted by customer number) I get no #'s in my calculated columns.
This is the formula in one of my calculated columns.

if
(
YEAR({Date}) = (YEAR(TODAY())-1)
,
{Amt}
,
0
)