• Sometimes the order of operations can have a significant effect on the way SSRS interprets the results of nested functions. It would probably be best to put the CDec function directly on the field2 value rather than wait to put it on the entire IIF() function. Like this:

    = Sum(IIf(Fields!UserField1.Value = 1, CDec(Fields!UserField2.Value), CDec(0)))