3 Replies Latest reply: Dec 12, 2014 10:09 AM by eric Johnson RSS

    Last year to date

      Hi wizards,

       

      i need your advice.

       

      I have this part of expression:

      sum({<Year_financial={$(=max(Year)-1)},Date=.....?????>}(Sale))

       

      Now i want - Calculate sales for last financial year, but only till actual date (i mean today is 15.8.2013, so calculate sales of last financial year till 15.8.2012 - financial year is from april till may, so give me sales from 1.4.2012 to 15.8.2012)

       

      I hope it´s easy for you ;-)

      Thx a lot

      Jaromir