5 Replies Latest reply: Jun 8, 2017 9:29 AM by Nicoals Martin RSS

    calculating variations by week

    Nicoals Martin

      hello,

       

      I have to calculate the result difference from a week day to another, but I didn't found any solution.

       

      Here is the objective (see "variation" column):

       

      DateProductSales ($)Variation ($)
      29/5/2017Apples25k-
      29/5/2017Bananas10k-
      29/5/2017Lemons6k-
      5/6/2017Apples21k+4k
      5/6/2017Bananas23k+13k
      5/6/2017Oranges19k-
      12/6/2017Apples39k+18k
      12/6/2017Bananas22k-1k
      12/6/2017Oranges12k-7k

       

      Do you have any idea?

       

      Many thanks in advance,

       

      Nicolas