condition

[#1]

Hello,

I put this expression to count Users who made orders in 2012 and 2013:

count({<Order-Year=2012, Order-Year=2013>}DISTINCT UserPK)

but it doesn't work, the second condition is not considered.

plz help

[#2]

Try this,

count({<Order-Year={2012,2013}>}DISTINCT UserPK)

Thanks

[somenathroy]

count({<Order-Year={'2012','2013'}>}DISTINCT UserPK)

Regards,

som

[alexandros17]

if Order-Year is a field you have to

count({$ <[Order-Year]={'>=2012<=2013'}>}DISTINCT UserPK)

hope it helps

[#5]

thank u, but it doesn't work

I have 781 users in 2012

          409 users in 2013

    when I use this expression it gives 906 users!!

it must be less than 409

[Gysbert_Wassenaar]

Try count({<[Order-Year]={2012}>,UserPK=p({<[Order-Year]={2013}>}UserPK)>} DISTINCT UserPK)

[#7]

the same result

[#8]

if(Order-Year=2012 and Order-Year = 2013, count(distinct UserPK))

[#9]

try this

count({<UserPK=p({<[Order-Year]={'2012','2013'}>}UserPK)>} DISTINCT UserPK)

[#10]

@ Mr. Gysbert Wassenaar : there is an error in this expression