5 Replies Latest reply on Mar 29, 2016 11:51 AM by Łukasz Majewski

    Compare two periods

    Mattia Pradella

      Hi All,

       

      I'd like to know from the experts how to compare two periods.

       

      Let's say something like:

       

      if [SALES] in period 1 > [SALES] in period 2 then "yes" else no

       

       

       

       

      For "Period" I currently use a fortnight calculated as below:

       

      DATEADD(

          'day',

          13-(DATEDIFF('day', #21/9/2014#, [Shift_Date]) % 14),

          DATETRUNC('day', [Shift_Date]))

       

       

       

       

      Any help will be much appreciated.

       

      Mattia