2 Replies Latest reply on Nov 15, 2018 4:09 AM by george.gousios

    Calculate field per hour

    george.gousios

      Hello ,

       

      I want to do a calculation per hour of values.

       

      In the data I am attaching, I have 2 hours intervals.

       

      So, in the first hour I want to do the calculation:  70 - 10 = 60

      In the next hour, I want to do :  150 - 70 = 80 and so on.

       

      I can create per hour field :

      DATEDIFF('hour', LOOKUP(ATTR([F11]), 0), LOOKUP(ATTR([F11]), 1))
      

       

      but I can't find a way to do the substraction in the time interval.

       

       

       

      Thanks!