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

    Calculate field per hour


      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.