1 Reply Latest reply: Nov 20, 2017 11:34 AM by Sunny Talwar RSS

    Compare 2 rows and show only rows with difference

    Ashish Palkar

      Hi There

       

      I have following data , I want to compare 2 immediate rows and show only those rows which has difference in Qty.

       

      Dim:

      LOAD *

      INLINE [

        ID, Qty, Version

        1, 400, 1

        1, 400, 2

        1, 500, 3

        1, 600, 4

        2, 600, 2

        2, 700, 3

        2, 500, 4

      ];

       

       

      Report Output should look like below:

       

      id

      oldqty

      newqty

      oldversion

      newversion

      Difference

      1

      400

      500

      2

      3

      100

      1

      500

      600

      3

      4

      100
      260070023100
      270050034-200

       

       

      Can you please suggest something?

       

      I tried with Above function.

       

      thanks in advance.