Thursday, 24 March 2016

Handle NaN error in SSRS or MDX

Hi Folks!
Today I learnt how to handle NaN error in SSRS. Use the below code for solution


=iif (Single.IsNaN(Sum(Fields!Sales.Value)),"",Sum(Fields!Sales.Value))

Thanks to my friend Anuj for suggesting me this code