Format a String to Number In SSRS

=Switch(
IsNumeric(Fields!dft_qty.Value),CINT(IIF(IsNumeric(Fields!dft_qty.Value), Fields!dft_qty.Value, Nothing)),
1=1,Nothing
)

Number -> Number

Else -> Nothing

Tweet