SSRS - #ERROR

This is bloomin annoying!

Have some code in a textbox and all should work fine.. The data that is incoming may contain either vb.net 'nothing' (null) or a numeric. So the following should work just fine:

=iif(Fields!Day_Before_Yesterday_Price.Value is nothing, "", Format(CDbl(Fields!Day_Before_Yesterday_Price.Value), "#,##0.0000"))

However, all that is shown in the SSRS report is either a numeric or #Error (when there is no data). This is nuts! SSRS is playing up! So to get around this error we have to add some code, see the screen shot and follow steps 1-4:

And hey presto no more #Errors!