Running Total

I try to sum the weight by putting the expression
=Sum(IIf(Fields!EQP_LEN.Value = 20 And Fields!EQP_TYPE.Value = "L", Fields!CONTAINER_WEIGHT.Value, 0))
in group footer section but #Error is returned. On the contrast if the expression: =Sum(IIf(Fields!EQP_LEN.Value = 20 And Fields!EQP_TYPE.Value = "L",1, 0))
No error is returned. Please help me !!!Can anyone help me ?
#Error is displayed in the cell.
"May Liu" wrote:
> I try to sum the weight by putting the expression
> =Sum(IIf(Fields!EQP_LEN.Value = 20 And Fields!EQP_TYPE.Value = "L", Fields!CONTAINER_WEIGHT.Value, 0))
> in group footer section but #Error is returned. On the contrast if the expression: =Sum(IIf(Fields!EQP_LEN.Value = 20 And Fields!EQP_TYPE.Value = "L",1, 0))
> No error is returned. Please help me !!!