Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
May be as below:
=Count(Distinct {$<'$(vValue)' = {'>= 3'}>}order_id)
If this doesn't work, can you please share the value in the variable vValue
which is the content of vValue??
Can you provide the sample data and expected output?
hi,
vValue holds: sum(flag_field)
flag_field contains (0/1)
hi,
vValue holds: sum(flag_field)
flag_field contains (0/1)
It is little confusing, because you are saying flag_field contains (0/1) but in the expression you want to check for >=3 ?. Can you please share a sample app with desired output.
my apologies,
flag_field contain 0/1 ;
and the value in the variable is an aggregation of flag_field: sum(flag_field)
Got it... Did you tried the expression ? If not are you getting any error ?
no error in the editor , but wrong calc..