• I don't know if it works or not. But you can try to create a calculated field with the 'iif' expression.

    And include sum(new calculated field) into the textbox...

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