12 Replies Latest reply: Jan 23, 2014 2:39 AM by Anton sineok RSS

    Ask two filters simultaneously.

    Anton sineok

      Ask two filters simultaneously.

      Hello!

      (sorry I do not speak in English )

      Try to set two filters at the same time , only one works . The situation is perhaps complicated by the fact that the report needed to compare data for different time periods (years) .

      first filter :

      sum ({ <CATEGORY_RU={'Sendvichi 15sm','Sendvichi 30sm','Salaty','Rolly','Beybi Saby','Sneki'}> } if (Day = DAYIsland, QUANTITY))

      - Working correctly.

      but if I add it to the second filter , output, over the past year - the filter does not work on the dishes - as if it is not.

      sum ({ <CATEGORY_RU={'Sendvichi 15sm','Sendvichi 30sm','Salaty','Rolly','Beybi Saby','Sneki'}> } {<Year={"$(vPrevYear)"}>} if (Day = DAYIsland, QUANTITY))

       

       

      For several days, I can not understand how to solve it . Thanks in advance !