9 Replies Latest reply: Mar 25, 2013 5:56 AM by jagan mohan rao appala RSS

    'and' in set analysis

    Hans Rokers

      Hello,

      I am strugling with the following:

      I need need the sales of last year, lower then the max week and lower then the current week.

      Something like:

       

      sum({$ <Year={$(=max(Year)-1)},Week = {"<$(=week(Today()))"} and Week = {"<$(=max(Week))"}  >} Sales )

       

       

      but this does not work.

      Any suggestions?