• I think "0.00" did provide some part of the solution but you need to look for NULL's and handle them which is giving you the error, i guess.

    Use the function IsNothing to handle NULL.=:

    iif( IsNothing(Fields!Sales.Value), 0.00, Fields!Sales.Value)

    Create a calculated field with the above expression.. just to check ...

    BI Developer
    SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
    Please visit... ApplyBI