2 Replies Latest reply: Jan 11, 2011 1:02 PM by Carlos Ayuso RSS

    Problems with expressions

    Carlos Ayuso

       

      I have a column (field) called [Nº Order] where the appears the order Nº. I have another column (field) called [Reason] where I get the different origins of orders including the value 'ZWW' if the order was placed online. My intention is to count the number of orders placed online.

      By introducing the expression:


      Count ({} <Motivo O ='ZWW'> DISTINCT [No Order])

      I returned the same as:


      Count (DISTINCT [No Order])

      And not all orders are online.

      I would appreciate if you can tell me a solution or explanation.

      Thanks!