6 Replies Latest reply: Jul 24, 2018 4:23 AM by V Kumar RSS

    issue while calculating the difference

    V Kumar

      Hi All,

       

      i am facing issue while calculating the difference.

      please find the below data with expected output.

       

          

      IDDistanceCreated_DateCustomerDiff_Distance
      11526-07-2017 06:39Cust10
      12027-07-2017 09:09Cust25
      12327-07-2017 09:39Cust13
      13427-07-2017 10:39Cust19
      14627-07-2017 13:54Cust112
      21301-08-2017 10:24Cust20
      24507-08-2017 07:54Cust232
      26716-08-2017 09:54Cust122
      24316-08-2017 10:54Cust2-24
      31216-08-2017 11:09Cust10
      31016-08-2017 13:24Cust3-2
      32316-08-2017 13:54Cust313
      33116-08-2017 23:39Cust38

       

       

      my expected output is diff_Distance.

       

      please help on the same.

       

      Thanks in Advance.