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

    Jess Garcia

      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:

       

      Count({$<(InRoomTm-ArrWaitTm)*1440)={"<=$(=30)"}>}(InRoomTm-ArrWaitTm)*1440))

      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?