Post reply

Converting SQL statement into SSRS calculation

  • 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_

  • 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.

  • 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
        )
    )

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

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