Converting SQL statement into SSRS calculation

• jeannier175

  SSC Veteran

  Points: 213

  More actions

  September 2, 2023 at 4:39 am

  #4277966

  I have a sql calculation  that i have no idea how to turn into a SSRS calculation expression any ideas?

   

  CASE
  WHEN SUM(CASE WHEN OPERATING_HOURS.IN_OPERATING_HOURS = 1 THEN 1 ELSE 0 END) IN (.,0) THEN 0
  ELSE ROUND(SUM(CASE WHEN OPERATING_HOURS.IN_OPERATING_HOURS = 1 THEN OPERATING_HOURS.DE_TAT_MINS ELSE 0 END) / SUM(CASE WHEN OPERATING_HOURS.IN_OPERATING_HOURS = 1 THEN 1 ELSE 0 END),.01)
  END) AS DATA_ENTRY_AVG_MINS_IN LABEL ="",
  ROUND(SUM(CASE WHEN OPERATING_

• Site Owners

  SSC Guru

  Points: 80332

  More actions

  September 3, 2023 at 5:10 am

  #4278472

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

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

• Sezam

  Ten Centuries

  Points: 1240

  More actions

  September 12, 2023 at 2:19 am

  #4284570

  You can try this:

  =IIF(
      SUM(IIF(Fields!IN_OPERATING_HOURS.Value = 1, 1, 0)) = 0 OR SUM(IIF(Fields!IN_OPERATING_HOURS.Value = 1, 1, 0)) = Nothing,
      0,
      ROUND(
          SUM(IIF(Fields!IN_OPERATING_HOURS.Value = 1, Fields!DE_TAT_MINS.Value, 0)) / SUM(IIF(Fields!IN_OPERATING_HOURS.Value = 1, 1, 0)),
          2
      )
  )