I'm attempting to add field DrAmt based on field TranType. So when TranType = "INT" then add the value in DrAmt. Here is my statement:
=iif(Fields!TrantypeID.Value = "INT",SUM(Fields!DrAmt),0)
When I run the report I receive this error:
[rsAggregateOfInvalidExpressionDataType] The Value expression for the textrun ‘textbox76.Paragraphs.TextRuns’ uses an aggregate function with an expression that returned a data type not valid for the aggregate function
Any help would be appreciated.