Nan,#Error,Infinity Values displaying in ssrs reports

• battula.ramu6

  SSC Veteran

  Points: 261

  More actions

  February 6, 2014 at 4:21 am

  #303783

  When I use calculation in generating reports, I get Nan,#Error,Infinity values in preview , I wanted to avoid this and display " " if the result of calculation is null or infinity..

  Please let me know how to avoid "NaN" and "infinity" and "#Error", while displaying in reports.

  when ever i see the prview NAN values are displayed and remaining fields are shows appropriate query results like percentage values Like 98%.00 some thing but i have a problem with "NaN" and "infinity" and "#Error" values i need to change those "NaN" and "infinity" and "#Error" values to " "

• higgim

  SSCarpal Tunnel

  Points: 4090

  More actions

  February 19, 2014 at 8:49 am

  #1690333

  have you tried wrapping it in an IF statement?

  =IIF(somecalculation > 0,somecalulation,"")

  or

  =IIF(ISNUMERIC(somecalculation),somecalculation,"")