2 Replies Latest reply: Oct 17, 2014 9:56 AM by Jan Heinrichsdorff RSS

    Sum last year until current calendarweek

      Hi experts

       

      I would like to compare the following values in a table:

       

      These are my formulas:

       

      1. Sum of my sales of the current year:

      Sum ({<Year={$(VmaxYear)}>} ([Sales]))

       

      1. Sum of my sales of the last year:

      Sum ({<Year={$(VPrevYear)}>} ([Sales]))

       

      BUT for last year only until the current week.

       

      How would I have to script this? I was thinking about defining a variable that is then inserted into the "Sum ({<Year={$(VPrevYear)}>} ([Sales]))" command.

       

      Thank you for your help!

       

      Jan