IsNumeric SSRS “NULL” Problem

My client had a desire to show that some numbers were “NULL” instead of either blank or zero (0) when they appeared on a particular report. I looked for a check box that might handle this but no thanks to SSRS I had to create an expression using the IsNumeric Function.

Check it out:

iif(IsNumeric(Fields!Quantity.Value),Fields!Quantity.Value,”NULL”)

If the Quantity is a number, it returns the number. Otherwise the word “NULL” is returned.