5 Replies Latest reply on Sep 27, 2017 4:35 AM by Steven Ming

    How to increment a field based on whether or not the value of a column changes to a different entry?

    Steven Ming

      Hello all,

       

      Currently I'm at a loss on how I can use LOOKUP, IF, AND and OR statements to implement a function to do the following:

       

      The function should examine whether the value of INDEX has changed or not, and if it hasn't, add the current price to the running total for a particular index. In the end the Running Total for a particular Index must be the entry for each row that has that particular INDEX. This is shown in the table below.

       

      INDEX
      PriceDelivery HourRunning Total for Price for each INDEX
      SE5110
      SE5210
      TS214
      TS224