5 Replies Latest reply: Oct 18, 2016 5:42 AM by Mohammad Sarif RSS

    Division Calculation is not working

    Mohammad Sarif

      Hi All,

       

      I have below table on my present data set.

      See very first row. I want Duration/Count = 58/1 = 58 and similarly for other rows. And In summary level also it is sum(duration) / count(number). But this is showing some weird value.

      My Script:

       

      Duration = Interval([closed_at] - [sys_created_on] ,'mm')

      Number Count = count(number)

      Duration/Count = Interval([closed_at] - [sys_created_on] ,'mm')/count(number)

       

      Could you please help on this.

       

      Thanks,

      Sarif