12 Replies Latest reply: Aug 29, 2018 12:01 PM by Mark Ritter RSS

    Need to Sum Results of Interval Function

    Mark Ritter

      I have the following calculation in my script.  It works perfectly to calculate the time difference.

       

      If (endtime > starttime,

             Interval(endtime - starttime,'m,ss'),0)

                                    as ProcessingMinutes,

       

      However, when I attempt to Sum or to a Total in my Table Chart I do not get close to the correct answer.

       

      For example the total based on my filter choices looks like a very large number.(in the thousands)  However, the total that is displayed using Sum(ProcessingMinutes) displays as 5.74.

       

      I suspect it has to do with the result from the interval function and that I need to do some massaging or additional calculations on it before I can Sum it.

       

      Thanks