AnsweredAssumed Answered

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

Question asked by tetrasync on May 25, 2017
Latest reply on May 25, 2017 by 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!

Outcomes