9 Replies Latest reply: Sep 30, 2013 3:45 PM by Mg Mg RSS

    How to average an expression column?

    Mg Mg

      Hi,

      my straight table consist of 2 columns: TIME as dimension, expression: [TIME]-above[TIME] to get the interval between each row.

      for example:

      time               interval

      00:01:00          00:00:00

      00:02:30          00:01:30

      etc..

       

      i am looking for a solution to be able to average the Interval column, i have tried by adding expression: avg(interval), but i get in each row of this 3rd column: '-'.

       

      can someone assist?

       

      thanks.

       

      Moti