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.