SUM() Function Trick

When using Iif() in SUM() function, make sure data types match. In the example below, if cDec() is not used, you will get an error.

=sum(iif(Fields!Sort_Order.Value = "E1", cDec(Fields!hours_m2.Value), cDec(0)))

The orginal post is at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1507530&SiteID=1