Error in conditional summing

  • I'm creating a SSRS report pulling from SSAS cube using a MDX Query.

    In my report I'm trying to sum conditionally inside a grid using the following expression.

    =Sum(iif((Fields!TOC_DIsplay.Value = "Default TOC" or Fields!TOC_DIsplay.Value = "Labor" or Fields!TOC_DIsplay.Value = "Non-Labor"),



    I'm getting the following error when the column has no values.

    Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: The specified operation is not valid.

    Any suggestions on fixing this error would be greatly appreciated.





  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply