Remove NaN and Infinity


  • Goal:
    I do not want to display the text NaN or Infinity in the object matrix list in SSRS. Instead, I would like to display whitespace than Nan and Infinity.

    In this context I only have access to SSRS and mdx only.
    I do not know how to remove NaN and Infinity.

    *Im using SSAS as a data source
    Monday, November 11, 2013 9:56 PM


  • Hi Sakura,

    Did you use similar expression in your report: =Fields!Amount.Value/Fields!Number.Value? In this situation, if we have divide by zero, we may get NAN or Infinity in the report.

    You can try to use the below expression to solve the issue:
    =IIF(Fields!Number.Value=0,Nothing, Fields!Amount.Value/IIF(Fields!Number.Value=0,1, Fields!Number.Value))

    If the issue is persist, please elaborate the issue for further investigation.

    Alisa Tang

    Alisa Tang
    TechNet Community Support

    Tuesday, November 12, 2013 9:57 AM