Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=Count({$<VCOHead_ordertype = {'O'}, OrderSource = {'F'}, OrderSource = {'I'}>}[CustomerID])
want to count the number of customerID when the ordertype is equal to 'O' and the OrderSource is equal to 'F' or OrderSource is equal to 'I' how can I write this up in the expression tab. currently I only see the count for the order type of 'I'
=
Count({$<VCOHead_ordertype = {'O'}, OrderSource = {'F','I','E','P'}}>}[CustomerID])
- this is what I used instead of breaking all the ordersource down into single. Merged the choices together..
close the request.