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
)

When the Viewis not summarized, you need to ensure that totals are enabled for the column - by default a calculated column does not have a summary operation at the bottom. Right-click on the column header and choose Display Total. Then when you summarize, you will get your subtotals.

Note that when desired, you can choose any of the other 3 summary operations (Min, Max or Average) and when summarizing a view, the operation will apply to each summary group.

I knew there was something I was missing, but couldn't recall what it was. Thanks