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.


      PriceDelivery HourRunning Total for Price for each INDEX