4 Replies Latest reply on Jun 15, 2016 10:08 AM by Maxime BENOIT

    Get next value inside the same field

    Maxime BENOIT

      Hello everyone,

       

      Here is my problem:

       

      - in Columns is the field "Time Processed"

      - in Rows is the field "Date Subscribed"

       

      I count data ids between these two fields (like a pivot table).

       

      I need to add the first and second existing values of each row (month of "Date Subscribed"), and make the result fit in the first column (month) of the field "Time Processed".

       

      Here is my table:

      tab.png

       

      Here is what I want:

      tab.png

      Is it possible to create a calculated field like this ? if yes, how ?

       

      Thank you in advance for your for your time,

       

      Maxime