Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Initially, we have tried with this calculation CASE WHEN Start Date < End Date AND Status1 <> Status2 THEN CASE WHEN CAST(Start Date AS DATE) = CAST(End Date AS DATE) THEN ROUND( ABS( TIMESTAMPDIFF(SQL_TSI_MINUTE, Start Date, End Date) / 60.0 ), 2 ) ELSE ROUND( ABS( TIMESTAMPDIFF(SQL_TSI_MINUTE, Start Date, End Date) /…