4 Replies Latest reply on May 25, 2017 10:09 AM by tetrasync

    Calculate the difference between two records based on information in the same field

    tetrasync

      I'm trying to build a calculation field that will calculate the difference between a new value and an old value the last time it was entered.

       

      For example I have clips that vary in duration but have been categorised into batches so for example batch 1 may look like this.

       

      Batch - Clipname - Duration

      1 - Clip001 - 52

      1 - Clip002 - 76

      1 - Clip003 - 19

      1 - Clip004 - 12

       

      The next time  around I'd import a similar list for Batch 2, note its the same clips just some have changed duration.

       

      Batch - Clipname - Duration

      2 - Clip001 - 37

      2 - Clip002 - 94

      2 - Clip003 - 19

      2 - Clip004 - 22

       

      How do I then go about creating a calculation field that will look for the previous import batch and compare the durations? So the field would show as + or -. So the calculation for Clip001 in Batch 2 would show as -15.

       

      Bit of a fiddly one but I'm sure its possible without scripting

       

      Many Thanks!