Problems with expressions

[#1]

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!

[#2 · Accepted solution]

Your Set Analysis syntax is incorrect. Try:

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

[#3]

It works!

THANKS!!!