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

    IF statement to deal with duplicates within fields

      Hi,

       

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

       

      For example:

       

      DateTimeIDDesc
      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.

       

      Thanks

       

      Raj.