Error in conditional summing

• raymo3u

  SSC Enthusiast

  Points: 115

  More actions

  February 7, 2024 at 11:26 pm

  #4375026

  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"),

  cdec(Fields!Next_Year_Budget__E_.Value),

  cdec(0)))

  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,

  Raymond

   

   

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  February 9, 2024 at 12:10 am

  #4375617

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

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