7 Replies Latest reply: Mar 26, 2015 8:09 AM by Manish Kachhia RSS

    Expression help? Compare last year and this year

      Hi

      I need to count items sold this year(ytd) and count items sold i the same periode last year as this year.

      ex. how many sold items from 1. jan 2014 to 26. march 2014 compared to same period this year

      So please help med with an expression something like this

      Maybe something with last maxDate or create a variable with something like

      =date(Today()-365,'DD-MM-YYYY')

       

       

       

      Count ({<AAR={$(vPreviousYear),$(vCurrentYear)}, sameperiod??>}items)