VBScript in Reports Expression Editor, filtering out certain values

Question

I have a report that need null values replaced with N/A. It works for x amount of rows until the null value is hit then the rest of the data needing to be displayed just goes away.

Here is my expression

=iif(Fields!PastBaseline.Value is nothing, "N/A", Round(Fields!PastBaseline.Value))

Anyone know what I am doing wrong?

Answer 1

Hi, i am not sure i have used similar thing s many time and it works fine. Try it like this

=iif( IsNothing( Fields!PastBaseline.Value ), "N/A", Round(Fields!PastBaseline.Value))

if this don't work can you see if there are any errors or warnings.

Best Regards, Iordan