10 Replies Latest reply: Jan 7, 2017 9:02 AM by Evgeny Stuchalkin RSS

    Calculated field, based on relative search in data table

    Evgeny Stuchalkin

      Hello! I have a table Calls like this:

       

      Call Date DD MM YYYYAbonent
      01.01.151
      02.01.151
      03.01.152
      04.01.151

       

      Table sorted accending by Call Date.

       

      For each call record i want calculate two fields:

      How many days passed since last call from abonent,

      How many days passed before next call happens.


      For example, for Call at 02.01.15 I weant to see: 1 day from last call, 2 days before next call.

      How to do this? I have not Idea.