3 Replies Latest reply: Dec 17, 2014 6:25 PM by Peter Cammaert RSS

    formula

      I have formula

       

      =Sum( {<BMIYEAR={"$(VARIABLEYEAR)"},BMIWEEKNR={"<=$(VARIABLEWEEK)"}>} SALES)

       

      variableyear equals 2013

      variableweek equals 2

      it gives me sales of year 2013 for weeknr 1 and 2

       

      but if i do

       

      =Sum( {<BMIYEAR={"$(VARIABLEYEAR)"},BMIWEEKNR={"$(VARIABLEWEEK)"}>} SALES)

       

      it doesnot give me sales of year 2013 for week 2, but sales of complete 2013.

       

      What do i wrong?