check more variabeles in one formula

[#1]

I am trying to count the orders of a specific product, but the result is not correct.

However in my table the correct orders are shown.

What am I doing wrong?

count({$ < Artikelgroep = {'CendrisMonitor'} > and $ <OMZET > 0 >} distinct(RELATIE_NAAM))

I am trying to count the unique RELATIE_NAAM for each record that has OMZET > 0.

Thanks!

Wouter

[Anonymous]

Hi Wouter,

I think you should try something like :

count({$ < Artikelgroep = {'CendrisMonitor'} ,   OMZET ={'0'}>} distinct(RELATIE_NAAM))

[#3]

Thanks, but unfortunately the OMZET has to be bigger than 0. Not equal to it...

[#4 · Accepted solution]

Hi,

Try this

count({$ < Artikelgroep = {'CendrisMonitor'} ,   OMZET ={'">0"}>} distinct(RELATIE_NAAM))

- Sridhar

[#5]

Thanks Sridhar, that was it (there was a ' too much, but I fixed that problem myself....  ) !!

Great!!!