The original description is wrong. The error occurs without zero values, too, unless all values are zero. The expression works in cells along the same footer row for integers and works on none of the currency columns. This is the expression: =sum( iif( Fields!Type.Value = "MyType", Fields!MyColumn.Value, 0 ))

It works fine for fields not of money type.