9 Replies Latest reply: Feb 9, 2017 1:26 PM by Sunny Talwar RSS

    Calculated duration in minutes, less than or equal to specified value

      I am trying to determine when a calculated duration is less than or equal to 30 minutes as a measure.


      I tried using the following:



      but there is an error, with no output




      Count(if(((PtInRoomTm-PtArrWaitTm)*1440) <=30, 1)) / count(all ((PtInRoomTm-PtArrWaitTm)*1440))

      but the output is incorrect


      Does anyone have a solution/fix to this?