Nan,#Error,Infinity Values displaying in ssrs reports

Question

I get Nan,#Error, Infinity values in preview when I use calculation in report generation, I wanted to avoid this and show" "if the calculation result is null or infinite.

Please let me know how to avoid"-1" and "infinity" and "# Error" during report display.

Whenever I see the preview NAN values are shown and the remaining fields indicate correct question results such as percentage values Like 98 percent.00 somewhat but I have a problem with the values"-1" and "infinity" and "# Error" I have to adjust those values to"

Answer 1

You often get these errors appearing in percentage calculations because of dividing by zero / null problems. It may take care to add phrases like the following (vary depending on what your percentage measurement is).

For null:

=IIF(Fields!Denominator.Value Is Nothing, "", (Fields!Numerator.Value - Fields!Denominator.Value) / Fields!Denominator.Value)

For zero:

=IIF(Fields!Denominator.Value = 0, "", (Fields!Numerator.Value - Fields!Denominator.Value) / Fields!Denominator.Value)

Check out Msbi certification training that enables you to master MSBI tools like SSIS, SSRS, and SSAS using SQL Server.