SSRS Expression

aarong · December 21, 2020, 2:29pm

Can anyone help me resolve this expression?

I’m trying to add two fields together to give me a total.

=iif(Fields!Calc_LineMiscTotal.Value="", Nothing, Sum(Fields!Calc_MiscTotal.Value)) + iif(Fields!Calc_MiscTotal.Value="", Nothing, Sum(Fields!Calc_LineMiscTotal.Value))

It’s giving me
#ERROR

Cheers,
Aaron.

cfinley · December 21, 2020, 2:36pm

Have you tried converting the data types?

CDec(Fields!Calc_LineMiscTotal.Value) + CDec(Fields!Calc_MiscTotal.Value)