5 Replies Latest reply: Mar 26, 2015 12:49 PM by Pedro Pereira RSS

    Expression with AND

      Hi,

       

      I want to calculate an expression where I want to count the products sold with price higher than 5e and the product type is chocolate by day. How can I do that?

       

       

       

      This counts the price higher than

      Count( {$<Price={"<=5"}>}Day

      )

       

       

       

       

       

      This counts the products equals to chocolate

       

      Count({$<Type={"Chocolate"}>}Dia)

       

       

       

       

      But I want the products with price higher than 5 AND type equal to chocolate.

      Can anyone help me?