4 Replies Latest reply: Dec 12, 2013 5:44 AM by anant dubey RSS

    Set Analysis Less then

    Gertjan van Luik

      Hi all,

       

      I have a set analysis to sum all sales before weeknumber 40 (40 is the result of a variable).

      SUM( {$< WeekNumber = { '<= $(vLastWeek)' } >} Amount)

      Now it selects all sales before week 40, also when I select in a Listbox weeks 10-20.

      Which set analysis should I use?

       

      Thanks!