variable with set analisys

[ilanbaruch]

hi all,

trying to count orders that are above value in a variable,

tried like this :

Count(DISTINCT{$<'$(vValue)' >= {'3'} >} order_id)

but.. wont work, any ideas?

[trdandamudi]

Please share some sample data with the required output, so that we can take a look and come up with a solution...

[vinieme12]

Try this instead

Count({<$(vValue) = {">=3"} >} DISTINCT OrderID)

Or

count(distinct if(sum(flag_field)>=3,OrderID))

or

count(distinct if($(vValue)>=3,OrderID))