Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello to all
I have an expression with Set analysis, to count the customers that have the condition-1, but do I want not to include the customer that have the condition-2 ¿How can make it?.
Example
Count
( {$<d_year={*}, d_month={*}, d_day={*}, Condition-1={'PREMIUM'},Date_num = {$(vPeriodo)} >} CustomerID)
¿ Where i add the condition-2 ?
Thanks
If you're looking to exclude any record that has a Condition-2, then make it equal an empty set.
That means only count when Condition-2 is null.Condition-2 = {}
Thanks,
But I need to count the customes that are condicion-1=PREMUIN and that Consicion-2 <> '1' (not equal to ' 1 ')
The -= is the Exclusion and should count only when Condition-2 does not equal 1.Condition-2 -= {'1'}
Thanks, for their help, it works well