Post reply

Converting SQL statement into SSRS calculation

  • September 2, 2023 at 4:40 am

    #4277967

    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_

  • September 3, 2023 at 5:10 am

    #4278473

    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