I have the following error which I can't understand from my expression.
=IIF(IsNothing(Fields!month.Value),"6mr",LEFT(Format(DateValue(MonthName(Right(Fields!month.Value, 2))
+ "," +
Left(Fields!month.Value,4)), "Y"),3) + " '" + RIGHT(Format(DateValue(MonthName(Right(Fields!month.Value, 2))
+ "," +
Left(Fields!month.Value,4)), "Y"),2))
This works perfectly without the IsNothing element.
I have tested the IsNothing element and that works in the following case:
=IIF(IsNothing(Fields!month.Value),"6mr",0).
Help to correct much appreciated.
See Question&Answers more detail:os