This thread shows that there are sometimes different ways to approach the logic. My expression gives the same answer as tresesco but the approach differs.
tresesco's expression says let's count customers that have bought a car and that have only bought one ProductType.
My expression says count up the customers but first exclude those who have ever bought a ProductType that was not a Car.
The good news is that if one way of approaching a problem has you struggling to write a code or expression then a rethink of the logic behind the question can lead you to writing a solution using functions and set operators you're more comfortable with.
thank you for the explanation. I think I better understand the different solutions now and both do not seem to fit. I should have explained the entire problem form the very beginning. What I am trying to do, is to group my users like in a VENN diagram and count the different units.
So something like: (if I have the productType car, house and food)
For your revised question the tresesco's expression is much easier to revise to give the answer. His expression now says count customers who have only bought a car or a house but have bought two distinct ProductTypes.
For my expression it's much more difficult to state the new logic in words even before rewriting it.
That's what I'm doing. I'm taking each sample and testing the result it delivers.
I was just giving Andrew the full picture of the problem. I did NOT expect him to give me the code for each use case in the Venn diagram... if that's what you think.
