3 Replies Latest reply: Sep 25, 2012 11:26 AM by rkapadia16 RSS

    IF statement to deal with duplicates within fields



      Is it possible to do calculations based on duplicates within the same field.


      For example:


      11/01/201212:20 PM1100007Alloc
      11/01/201212:17 PM1100007Alloc


      What I need to do is, if the IDs are the same (i.e. 1100007 = 1100007) and the Desc's are the same (i.e. Alloc = Alloc), then work out the absolute difference of the "Time" field (which is 3 minutes in this example).


      I'm not sure what syntax to use which will enable me to do this.


      Any help would be greatly appreciated.