conditional sum not working on certain datatypes

Question

I have a conditional sum in my grouping

=sum(iif(Fields!Letter.Value="Service",0,Fields!Mailed.Value))

I keep getting the #error on half the fields. There all numbers. In my proc im calling the fields that are erroring outare doing a calculation. I tried putting those into a subquery and calling and it errored out. Im not sure where to go from here.

Any ideas on why this may be and how to fix it?

Answer 1

The only thing I can think of is to check that data types that you are using

Answer 2

IIf Condtion Returns as object .Parse the object to Numeric like decimal or integer and sum .