3 Replies Latest reply: May 23, 2017 11:08 AM by Antonio Mancini RSS

    Compare dates values

    Nicoals Martin

      Hello all,

       

      I have a data sets with different dates.

       

      I'd like to compare values coming from 2 different dates, for instance:

       

      ProductDateValues
      Apples20/5/201715000
      Pears20/5/20173000
      Carrots20/5/201760000
      Apples27/5/201745000
      Pears27/5/20176000

       

      Result

       

      Difference from 20/5 to 27/5:

      Apples: + 30000

      Pears: + 3000

      Carrots: none

       

      Do you have a solution (either in script or expression)?

       

      Many thanks in advance,

       

      Nicolas