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:




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

          DATETRUNC('day', [Shift_Date]))





      Any help will be much appreciated.