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


      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.