Hi I have a report containing a column in which the numeric value is obtained by an expression... =IIF (Fields!PartPalletCartons.Value="0","0","1") I need a total row for this column but I can't seem to find the right syntax. I have tried the below but although the syntax is accepted, the cell displays as "#Error". Could anyone help with this please? =Sum(IIF (Fields!PartPalletCartons.Value="0","0","1")) Regards Steve

Appears that I just didn't need the quotation marks around the value to insert, the following worked... =Sum(IIF (Fields!PartPalletCartons.Value="0",0,1))